Home > SQL*Plus > F7: Handy SQL*Plus Shortcut Key

F7: Handy SQL*Plus Shortcut Key

F7 shortcut MenuWhen using SQL*Plus via the Command Prompt in Windows, you can press F7 on the keyboard at any time to view a list of all the recent commands that you have run (see image on the left). You can scroll up and down the list with the arrow keys and replay any of the commands using the Enter key.

This is a feature of the Command Prompt but is particularly useful when working with SQL*Plus.

One other handy feature of the Command Prompt (again with particular relevance to SQL*Plus) is that you can press the UP and DOWN arrows to cycle through a history of commands that you have issued.

Anyone know of any other nifty shortcuts for use in SQL*Plus?

Advertisements
Categories: SQL*Plus
  1. Sam Kolta
    May 6, 2010 at 4:27 pm

    Function Keys
    Function Key Action
    F1 Bring up previous command character by character
    F2,4,10,11,12 No action
    F3 Bring up the last row in the previous commands
    F5 Bring up the last row in the previous commands
    F6 + Enter Exit from oracle
    F7 Viw a list of all the recent commands that you have run (see image on the left). You can scroll up and down the list with the arrow keys and replay any of the commands using the Enter key
    F8 One click: Bring the most recent commands and by repeat clicking: different command will bring up
    F9 Popup short menu to type your command number then press enter to paste it

  2. chr
    July 17, 2007 at 10:59 am

    F3 to paste last command

  3. Franco
    May 25, 2007 at 8:43 am

    F2 (to copy “up to” from the last command) and F4 (to delete “up to”, but I didn’t understand how it works…)

    Thanks for the hint on F7, nice to know :-)

  4. May 24, 2007 at 9:19 pm

    I didn’t know that with F7, good tip. I’m using SQL*Plus not to often anymore, but sometimes I do.

    Patrick

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: