-
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 )
-
Why don't you just run a SPOOL?
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|