Find previous executed SQL

[pande.dhiraj]

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

[susarlasireesha]

Use Sys.V_$SQL

[supari]

Use Sys.V_$SQL

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

[nandita_nag]

Run the below query to fetch the last executed SQL

select * from sys.V_$SQL
order by FIRST_LOAD_TIME desc