simple sqlplus question

Hi, I have a simple sqlplus question. Is there a way that you can retrieve a series of sqlplus statements from sqlplus? I don't mean just the last command from the buffer but a history of commands since one logged onto sqlplus? If so, could someone give me a little info on this?

Thanks,
Will Landstrom

The only thing close to that functionality is in MS-DOS (use the cursor arrows to have commands reappear on the command line). I personally submitted an enhancement request to Oracle about this issue (being able to recall commands while in a SQL*Plus session). If Oracle likes an enhancement request, you see it as a new feature. If not, tough luck.

Or, you could just use a real application like T.O.A.D, SQLStation, Ebarcadero, PL/Edit, EZSQL (if you still have a copy :(), etc., etc.

- Chris

(sorry, cheap shot - couldn't resist :D)

If you run a SPOOL of your session you will get all the keystrokes and results.

FILE|SPOOL and use a txt editor to view.

hth & is on topic...Frog

I think sql*worksheet store hist commands

u can use v$sqltext view to get those sql ...how to do am leaving to u