Home » RDBMS Server » Server Administration » How to retrieve the latest query fired in Sql?
How to retrieve the latest query fired in Sql? [message #374567] Tue, 19 June 2001 04:57 Go to next message
Rajee
Messages: 17
Registered: June 2001
Junior Member
Hi,
How to retrieve the latest queries fired in sql.
With regards,
rajee

Report message to a moderator

Re: How to retrieve the latest query fired in Sql? [message #374574 is a reply to message #374567] Tue, 19 June 2001 10:29 Go to previous message
Andrew again...
Messages: 270
Registered: July 2000
Senior Member
in sqlplus, enter 'l' to list the last command.

SQL statements still in the cache within Oracle are available in v$sql_area and V$SQLTEXT_WITH_NEWLINES - but you can't specificaly see which was last.

Report message to a moderator

Previous Topic: Querying single quotes in varchar2 field using Run_Product for Reports.
Next Topic: Join command help
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jul 06 00:53:17 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.