<< Click to Display Table of Contents >>

Standalone SQL editor

Top Previous Next

The following main menu structure is available only in the standalone SQL editor:

File

144_FileNew

New

Clears editor window for editing a new file.

 

45_FileOpen

Open

Opens a file

 

 

Reopen

Lists the most recently viewed files

 

46_Save

Save

Saves the contents as a file

 

 

Save as

Saves editor contents to another file

 

01_Print

Print

Prints a file

 

159_Compare

Compare

Invoke the File Comparison tool

 

 

Exit

Exits the standalone editor

View

 

Status bar

Toggles visibility of the status bar.

 

 

DBMS output window

Toggles visibility of the DBMS output window (when connected to the database).

Database

79_Connect

Connect

Displays the connect dialog for establishing a database connection. This is required for running SQL scripts or retrieving information from the Data Dictionary. However, you can edit files without connecting to a database server.

 

 

Disconnect

Disconnects the SQL editor from the database.

 

156_ExecuteScript

Execute script

Executes selection of the entire editor contents.

Edit

24_Undo

Undo

Undoes the last action

 

25_Redo

Redo

Redoes last action

 

21_Cut

Cut

Cuts out the selected text and puts it to the Windows clipboard.

 

06_Copy

Copy

Copies the selected text to the Windows clipboard.

 

23_Paste

Paste

Pastes clipboard contents to the selected location.

 

 

Select all

Selects entire editor contents.

Search

00_Find

Find

Finds text

 

 

Search Again

Repeats last search

 

14_SearchReplace

Replace

Replaces text

 

15_GotoLine

Goto Line number

Goes to line number

 

167_ClearBookmark

Clear all bookmarks

Clears all bookmarks.

Format

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

 

17_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 selected block.

 

 

Comment out selected text

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

 

26_UpperCase

Upper Case

Converts selected characters to upper case.

 

27_MixedCase

Mixed Case

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

 

28_LowerCase

Lower Case

Converts selected characters to lower case.

Extras

 

Properties

Displays the properties dialog for customizing the editor.

Help

 

Contents

Displays online help

 

 

Registration

Lets you register KeepTool or view the License Agreement

 

 

System

Environment

Information

Gives particulars about the current version of KeepTool, the client software,  and the Oracle Server.

 

 

About

Displays the About dialog

The standalone SQL Editor supports syntax highlighting for

SQL and PL/SQL files

Oracle configuration files (tnsames.ora, etc.)

Java files

and plain text files.

Optional saving of files

The standalone editor will prompt you to save a new file before executing the code if the Save Editor before Execution box on the SQL Page tab of the Extras | Settings menu item is checked. Leaving it unchecked will enable the Edit | Undo and Edit | Redo features on the context menu until you actually save the file.