<< Click to Display Table of Contents >>

SQL Editor component

Top Previous Next

The SQL Editor component is present in both the standalone SQL Editor and various Hora forms, such as the code window of the SQL Scratchpad and the Source Code tab of the PL/SQL Objects page.

The following menu is always available to the SQL editor component, i.e. in both the embedded and standalone file editor:

 

147_EditInNewWindow

Edit in new window

Opens a new window, where the code window is expanded into the space normally occupied by the SQL Scratchpad and the File Explorer

200_SqlEditor

Open in SQL editor

Opens file in separate SQL editor.

File

 

 

 

 

 

 

 

144_FileNew

New

Clears editor window to create a new file (Separate SQL editor only)

45_FileOpen

Open

Opens a file

46_Save

Save

Saves the contents as a file

 

Save as

Saves editor contents to another file

 

Close

Close file

159_Compare

Compare

Opens the File Comparison tool

168_Email

Send Email

Opens the email client and attaches the file

01_Print

Print

Prints the contents of the editor

Query

 

 

 

 

 

 

 

 

50_ExecuteQuery

Execute Query

Executes selection as a single SQL statement or anonymous PL/SQL block. You can browse (and under some circumstances modify) the result set.

156_ExecuteScript

Execute script

Executes multiple SQL statements or PL/SQL blocks.

163_SqlPlus

Execute with SQL*Plus

Sends the contents of the code window to SQL*Plus for execution

78_ExplainPlan

Explain Plans

Shows execution plan for the selected statement

187_ResetColor

Reset background colors

Removes the shaded background used to highlight code that encountered errors.

44_QueryBuilder

SQL Query Builder

Runs the SQL query builder, which generates insert, update or delete statements. Column information is retrieved from the Oracle Data Dictionary.

165_Profiler

Profiler

Runs the DBMS_PROFILER modal dialog.

105_SqlHistory

Recall command from SQL history

Displays previously issued SQL in the left pane. Any statement may then be selected, bringing it into the SQL Editor in the right pane.

 

Show SQL result

 

Selected Object

97_Describe

Describe

 

 

Expand SELECT

 

 

Expand INSERT

 

 

Expand UPDATE

 

 

Expand CURSOR FOR LOOP

 

 

Expand SELECT records without details

 

 

Show Data

 

Edit

 

 

 

 

 

24_Undo

Undo

Undoes the last action

25_Redo

Redo

Repeats the last action

21_Cut

Cut

Cuts the selected text and moves it to the Windows clipboard.

22_Copy

Copy

Copies the selected text to the Windows clipboard.

23_Paste

Paste

Replaces the current selection with the contents of the Windows clipboard.

 

Select all

Selects the entire contents of the editor.

 

Delete Line

 

Search

 

Oracle Help

Sends selected string to Oracle' search facility.

 

00_Find

Find

Finds text

 

13_SearchAgain

Search Again

Repeats the last search

 

14_SearchReplace

Replace

Replaces text

 

15_GotoLine

Goto Line number

Goto line number

 

19_ToggleBookmark

Toggle bookmark 0

Toggle bookmark 0 at current line

 

 

Toggle bookmarks 1..9

Opens additional menu to toggle a bookmark between 1 and 9

 

20_GotoBookmark

Goto bookmark 0

Go to bookmark 0

 

 

Goto bookmark 1..9

Opens additional menu to toggle a bookmark between 1 and 9

 

167_ClearBookmark

Clear all bookmarks

Clears all bookmarks.

 

18_Indent

Indent

Indents selected block by inserting a tab as first character of each selected line.

 

17_Unindent

Unindent

Removes tab indent from current selection

 

47_QuoteBlock

Quote block

Comments selected block by inserting '--' as first characters of each line.

 

48_UnquoteBlock

Unquote block

Removes '--' at the beginning of each line from the selected block

 

 

Comment out selected text

Inserts /* at the beginning of selected text, and */ at the end.

 

26_UpperCase

Upper case

Converts selected characters to upper case.

 

27_MixedCase

Capitalize

Converts selected characters to lower case, except that the first character of each word will be converted to upper case.

 

28_LowerCase

Lower Case

Converts selected characters to lower case.

Extras

 

Properties

Displays a properties dialog for customizing the editor.