Friday, May 9, 2014

Useful SQL Developer Shortcuts

A short list of some useful shortcuts of SQL Developer.


Key
Description
Ctrl+Alt+R
Check for updated data
Ctrl+Alt+W
Toggle focus between popup and primary window
Ctrl+/
Toggles line commenting
Ctrl+Alt+0. . .Ctrl+Alt+5
Switch diagram layout
Ctrl+5
Strikethrough
Ctrl+A
Select all
Ctrl+B
Boldface
Ctrl+Alt+C
Toggle source code editing
Ctrl+E
Center alignment
Ctrl+H
Create hyperlink
Ctrl+Shift+H
Remove hyperlink
Ctrl+I
Italics
Ctrl+L
Full justified alignment
Ctrl+Shift+L
Left alignment
Ctrl+Alt+L
Numbered list
Ctrl+M
Increase indentation
Ctrl+Shift+M
Decrease indentation
Ctrl+Alt+M
Launch context menu
Ctrl+R
Right alignment
Ctrl+Alt+R
Toggle rich text editing
Ctrl+Shift+S
Clear text styles
Ctrl+U
Underline
Ctrl+Y
Redo
Ctrl+Z
Undo
Ctrl+Shift+^
Go up one level
Ctrl+N
New file will be open.
Ctrl+O
Opens the existing file.
Alt+V+C
Opens the connections window.
Alt+F10
Select connection and open new worksheet.
Ctrl+Shift+D
Duplicate the line
Ctrl+'(Single Quote)
Toggle the case (Upper/Lower/Initcap)
Ctrl+ Enter
Executes the current statement
Ctrl+ Space
Invokes code insight on demand
Ctrl-Up/Dn               
Replaces worksheet with previous/next SQL from SQL History
Shift+F4               
Opens a Describe window for current object at cursor
Ctrl+F7    
Format SQL
Ctrl+ Space
Executes the current statement

As a developer I used Bold ones the most. They are my favorite.

Thursday, May 8, 2014

Toggle case in SQL DEVELOPER

Toad users find SQL developers shortcuts bit difficult. I searched a lot and then finally find out the shortcut for CASE TOGGLE in SQL Developer as well



Ctrl+'(Single Quote)  -->   Toggle the case (Upper/Lower/Initcap)

Sample Query:     select emp_id , emp_name from employees


1) On Ctrl+'(Single Quote) query change all keywords to upper case

SELECT emp_id , emp_name FROM employees


2) On again doing Ctrl+'(Single Quote) full query changes to upper case except keywords

select EMP_ID , EMP_NAME from EMPLOYEES


3) On again doing Ctrl+'(Single Quote) full query changes to upper case except keywords

Select Emp_Id , Emp_Name From Employees


4) On again doing Ctrl+'(Single Quote) full query changes to upper case

SELECT EMP_ID , EMP_NAME FROM EMPLOYEES


5) On again doing Ctrl+'(Single Quote) full query changes to lower case

select emp_id , emp_name from employees