Oracle Database 12c Release 2 - SQL*Plus History Command
As you know that we can repeat our previous SQL*Plus commands in Windows CMD. But in UNIX based systems not supported command line history of SQL*PLus. For this reason in UNIX and Linux, we used rlwrap utility to see the SQL*Plus command line history and quickly recall previous SQL*Plus commands. With seconds release of Oracle Database 12c coming SQL*Plus history command for the history of the command line in Linux. I want to share some example for this command: Before using History we must enable history command as below: SQL> set history on The syntax of HISTORY command as bellow SQL> help history HISTORY ------- Stores, lists, executes, edits of the commands entered during the current SQL*Plus session. HIST[ORY] [N {RUN | EDIT | DEL[ETE]}] | [CLEAR] N is the entry number listed in the history list. Use this number to recall, edit or delete the command. Example: HIST 3 RUN - will run the 3rd entry from the list. HIST[ORY] without any option
Comments
Post a Comment