Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2001
    Location
    Baton Rouge
    Posts
    13

    Unanswered: View a query after running it

    Hi
    This is the first time I am using Oracle. I wanted to know how to view the query on the command line after running it..I wanted to check the query I wrote but I am unable to do so. I can see the output but want to view the query I wrote
    Can some one help
    Thanks

  2. #2
    Join Date
    Feb 2001
    Location
    NC, USA
    Posts
    200
    Assuming you're using SQL*Plus:
    Code:
    SET ECHO ON
    SET FEEDBACK ON
    There's also a bazillion other SET commands that can alter the way the output appears.

  3. #3
    Join Date
    Nov 2001
    Location
    Baton Rouge
    Posts
    13
    Hi
    I know i sound an illeterate..I tried it, can u be alittle more elaborate
    THanks a ton for the quick reply and the help
    I am using Sql *Plus
    thanks again

  4. #4
    Join Date
    Feb 2001
    Location
    NC, USA
    Posts
    200
    Hmm.. it works for me. At the SQL prompt, just enter those lines. You actually only need the 'set echo on' line to see the SQL.

    Are you really using the command line version, or is it the GUI version that looks like a white command shell?

  5. #5
    Join Date
    Nov 2003
    Location
    India
    Posts
    114

    Re: View a query after running it

    Originally posted by noswal
    Hi
    This is the first time I am using Oracle. I wanted to know how to view the query on the command line after running it..I wanted to check the query I wrote but I am unable to do so. I can see the output but want to view the query I wrote
    Can some one help
    Thanks
    Just type l; (This is L)

    You will see ur last query

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •