1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Data Retrieval Queries

Discussion in 'SQL PL/SQL' started by kishore garlapati, Oct 25, 2010.

  1. kishore garlapati

    kishore garlapati Active Member

    Messages:
    15
    Likes Received:
    1
    Trophy Points:
    110
    HI
    Is there any Sql statement for retrieving of data/records instead of SELECT statement,in sql.
    And also could any body explain about autotrace on and sql trace functionality.








    Thanks In Advance.
     
  2. SBH

    SBH Forum Expert

    Messages:
    99
    Likes Received:
    6
    Trophy Points:
    160
    Location:
    Bangalore
    SELECT is the only query command in Oracle for selection of data from database.
    AUTOTRACE is a command used in SQL Plus to get explain plan for each statement executed in SQL Plus.
    SQL Trace is a method to analyze the explain plan of a query and get the optimizer's access path to process a SQL statement. You can google for further information on web