Posted by : Arjun Lagisetty Wednesday, December 7, 2016

Most Useful Shortcuts:

Block Comment
CTRL+B
Comment selected lines
Uncomment
CTRL+SHIFT+B
Uncomment Selected lines
Format Code
CRTL+SHIFT+F
Format and indent code.
Describe
F4 or ALT + Enter
Opens a new window describing the table
Lower case
CRTL+L
Convert all the text to lowercase
Describe Select Query
CRTL + F9
Opens a new window describing the select statement
Execute Statement
F9
Run SQL code and show results in Script Output tab
Execute Script
F5
Run SQL code and show results in Data Grid
SQL Recall
F8
Opens a section which shows all the SQLs run
Previous SQL Recall statement
ALT + up
Acts like history navigation in bash shell for SQL commands
Next SQL Recall statement
ALT + down
Acts like history navigation in bash shell for SQL commands
Next Navigator Node
CRTL+PgDn
Goes not next statement block in the editor
Previous Navigator Node
CRTL+PgUP
Goes not previous statement block in the editor
Quick Template
CRTL+Space
Opens a prompt on the editor with all template for code blocks like begin end, for loop,etc



Helpful Views:

View>Code Snippets
Provides sample code snippets like hints, date formats, conversion functions (quick alternative to googling for synrax)
View>Object Palate
Used for building queries by selecting object name and column name by dragging and dropping them into editor

Leave a Reply

Subscribe to Posts | Subscribe to Comments

Popular Post

Labels

Blog Archive

Copyright © ODI Pundits - Oracle Data Integrator - Maintained by Arjun Lagisetty