Thursday, November 3, 2011

Most useful Oracle Sql Developer shortcut keys

PROBLEM:
You are using Oracle Sql Developer and you want to use some useful shortcut keys

SOLUTION:
F5 - Runs the selected statement (if selected) or run all script in page. The output is NOT formatted
F9 - Same as F5, the output is formatted
CTRL+ENTER - Runs the current statement without selecting it (very useful!)

Select your query and press F5/F9, this will run only the select query



Put your cursor somewhere in the text of your query, press CTRL+ENTER. The query in the scope of your cursor will run. The scope is from the last ";" until current query ";"




If you find this solution useful, you are welcome to press one of the ads in this page.. Thanks!


16 comments:

  1. good..thanks ..
    i want more..like add command line,
    copy a column header name..

    ReplyDelete
  2. I as of late went to the DevOpsDays Seattle gathering and needed to share a portion of the subjects of discourse with the devops roles group of onlookers.

    ReplyDelete