Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2010

    Unanswered: Recall SQL Commands

    Is it possible to recall a history of your session SQL commands.
    I understand you can use L to recall the last SQL statement,
    but what about a history of SQL statements while you have
    been logged into SQL Plus?

    Many thanks

  2. #2
    Join Date
    Jan 2010

    alternate solution

    If you are using sql * plus then make the spool on , it will record all the commands and their output. But if you are running queries that produces huge output then you need to watch the spool file size. Not sure if there is a command like history ( Unix Shell) present in sql.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts