retrieve commands from committed database

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ayush dargar

    #1

    retrieve commands from committed database

    hello ....
    i'm working in oracle 10g
    i was making my project in sql plus n after completing it i forgot to spool off and closed the sql plus i commited the database but i want my all those commands i wrote then
    do anyone know a way through ...............
  • amitpatel66
    Recognized Expert Top Contributor
    • Mar 2007
    • 2358

    #2
    You can check in v$sql:

    [code=oracle]
    select * from v$sql
    /
    [/code]

    Comment

    Working...