Interface

SQL*Plus Commander has a text Interface.
Most of the screen contains data
Only the first (header) and the last (footer) rows in the screen contains other informations:

Header

Name o Connection
Type of page (SQL/Internal)
Breadcrumb
Level
Script or menu code
SQL_ACTION (parameter passed to the script)
KEY (paramater &1 passed to the script)

Footer

Feedback about position and last key pressed
Filter
Time elapsed

You can move a cursor line through data rows with cursor keys (up, down, right, left) trough data
On most common terminal even home, end, pageup, pagedown should work fine.

Common Commands

The following commands are activated on every page, and cannot be used for custom operations
"Q" go back to upper level / quit
"R" or "F2" refresh data (re-executes script)
"E" or "F4" Edit source sql script (not working on pages based on internal funcionn)
"H" or "F1" help page (viewed with less, Q to exit). Help page is dinamic, and follow configuration in file spcmd.def
"/" Search a data for a pattern and filter results (like grep). When starting a search, the script will not be executed again, and the filter will be kept on refresh of data.

back to [Home]