Infolinks

Saturday, 23 June 2012

ORACLE SQL DEVELOPER

ORACLE SQL DEVELOPER


ORACLE SQL DEVELOPER

ORACLE SQL DEVELOPER
Editor Shortcuts

SIHFT+F4 Popup Describes the object.

F5 Executes an SQL script.

F6 Execute Explain Plan
F10 Auto Trace.
F11 Commit.
F12 Rollback.

F9 Executes an SQL statement OR   CTRL+ENTER.

F8 Recalls the previous SQL statement History.
CTRL+up arrow or down arrow Recalls the previous SQL Statements.
CTRL+SLASH  line Comments
CTRL+SHIFT+L  Log
CTRL+SHIFT+F9 Compile
CTRL+F7  Format Code
CTRL+D Clear
CTRL+P Print File




Auto Trace For SQL Statements F6



Enable PLSQL DBMS Output
click on DBMS Output tab and click on left side one redmark button one click on and another click off.

No comments:

Post a Comment