Hi all
Can anybody tell me the query to find out the last or previous some executed SQL by SQL command prompt.
it doesnt matter it is executed by application or the SQL command prompt
thanks in advance
Printable View
Hi all
Can anybody tell me the query to find out the last or previous some executed SQL by SQL command prompt.
it doesnt matter it is executed by application or the SQL command prompt
thanks in advance
Use Sys.V_$SQL
[QUOTE=susarlasireesha;20835]Use Sys.V_$SQL[/QUOTE]
susarla,
Use Sys.V_$SQL
executing the above in Oracle SQL Developer
gives "Invalid SQL Command"
Do we execute in SQL Plus*????, give the exact steps
Run the below query to fetch the last executed SQL
select * from sys.V_$SQL
order by FIRST_LOAD_TIME desc