TOAD FOR ORACLE MANUAL

TOAD FOR ORACLE MANUAL

TOAD FOR ORACLE MANUAL

TOAD FOR ORACLE MANUAL 

Editor Shortcuts 

F4 Describes the object next to the cursor. 

F5 Executes an SQL script. 

F6 Toggles between the Editor and Grid. 

F9 Executes an SQL statement. 

F8 Recalls the previous SQL statement. 

CTRL N Adds the selected statement to named SQL Recall. 

CTRL MINUS Comments the selected line. 

CTRL SHIFT MINUS Uncomments the selected line. 

TAB Indents the selected line. 

SHIFT TAB Outdents the selected line. 

CTRL SHIFT 0–9 Sets a numbered bookmark at the selected line. 

CTRL 0–9 Go to the numbered bookmark. 

SHIFT ESC Sets a position indicator at the cursor location 

ESC Pops the position indicator. 

CTRL SHIFT R Start/Stop recording a macro. 

CTRL SHIFT P Play the recorded macro. 

CTRL L Converts the selected text to lowercase. 

CTRL U Converts the selected text to uppercase. 

CTRL C Copies the selected text to the clipboard. 

CTRL X Cuts the selected text for pasting in the clipboard. 

CTRL V Pastes text from the clipboard. 

CTRL SHIFT V Pastes items from the Clipboard Ring. 

HOME Moves the cursor to the beginning of the line. 

CTRL HOME Moves the cursor to the beginning of the file. 

END Moves the cursor to the end of the line. 

CTRL END Moves the cursor to the end of the file. 

CTRL ] or CTRL [ Moves the cursor to the matching bracket 

BACKSPACE Deletes the selected text (if text is selected); otherwise, deletes the previous character. 

CTRL BACKSPACE Deletes text to the beginning of the previous word. 

CTRL DELETE Deletes text to the beginning of the next word. 

CTRL SHIFT DELETE Deletes the entire line. 

CTRL F Finds text. 

F3 Finds the next occurrence of text. 

SHIFT F3 Finds the previous occurrence of text. 

CTRL G Go to line number. 

CTRL I Performs an incremental search.

CTRL SHIFT I Performs a reverse incremental search. 

ESC Exits the incremental search mode. 

CTRL PERIOD Displays a drop-down list in the Editor so you can quickly select a database, table, or column. 

CTRL UP Scrolls up the window. 

CTRL DOWN Scrolls down the window. 

SPACE Automatically replaces a misspelled word, inserts symbols, and expands text. 

CTRL SPACE Displays the Code Snippets folder browser. 

CTRL SPACE Inserts the code snippet template. 

CTRL DELETE Sets the column value for the current cell to Null in the data grid. 

Debugger Shortcuts 

F7 Step into 

SHIFT F7 Step out 

F8 Step over 

F11 Run to breakpoint 

F12 Run to cursor 

CTRL B Set breakpoint 

CTRL W Add watch at cursor 

If u don't know basic plsql syntax

Press CTRL SPACE it will display all plsql syntax's look like below screen.

The below screen show SQL statement and after pressing CTRL+ENTER OR F9 we will get data.

If u want to Create new session (Connection) Go To Session Tab and Click on NEW Connection.

Enter User Name (SCHEMA) : SYSTEM

PASSWORD : TIGER

TNS NAMES( SID) : ORCL

CONNECT USING : Oracledb10g_home1

Click on CONNECT Button.

If u want to open existing sql files

Go To File Tab and Click on OPEN FILE

If u want to open existing sql files

Go To File Tab and Click on OPEN FILE

Cost based tuining

How to find the cost of a Query

Go To Editor Tab & click on Explain Plan for current SQL OR Press CTRL+E

The below screen shows the cost of a sql query

If u want save the out put data

Right click on data and click on SAVE AS option

And Specify the Data file Name and location

and include column headers and Comma separated & click on OK Button

The below screen shows the select statement for output data...(DATA SET)

data file..

If u want to export data as a data file and include create control file..

Right click on Data and click on export to flat file....

Go To Spec File Tab and Click on Generate Columns

Click on SAVE SPEC File and

Go To Options Tab and

Select To File

Enter Data file name

Go To SQL Loader Tab

Click on Save Options and Execute button.