simple sqlplus question
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: simple sqlplus question

  1. #1
    Join Date
    Sep 2002
    Posts
    4

    Cool

    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

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    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.

  3. #3
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    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 )
    Christopher R. Long
    ChrisRLong@HotMail.Com
    But that's just my opinion. I could be wrong

  4. #4
    Join Date
    Apr 2002
    Posts
    14

    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


  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    I think sql*worksheet store hist commands

  6. #6
    Join Date
    Aug 2002
    Posts
    35
    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
  •  


Click Here to Expand Forum to Full Width