Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Location
    New York
    Posts
    45

    Unanswered: Pull sql from ora table

    Hello,

    Is there a table, dba_table that keeps the info of the query (sql) that was run?
    Partic. sql statement itself ?

    Thank you

  2. #2
    Join Date
    Oct 2004
    Posts
    145
    Check out table v$sqlarea to see if this is what you are looking for.

  3. #3
    Join Date
    Feb 2004
    Location
    New York
    Posts
    45
    Quote Originally Posted by JimYoo
    Check out table v$sqlarea to see if this is what you are looking for.




    Thank you so much,

Posting Permissions

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