Home

SQL*Plus Commander is a Text-based user interface (TUI) to run your own queries in a very fast and smart way
Moreover, data resulting from a query can instantly selected and passed as parameters to linked scripts

For example, in a set of data related to human resource, you can browse table of departments, and for some departmens you can view immediatly the list of employees.
Normally, using SQL Developer or other similar tools, you keep 2 queries on screen ad with a lot of copy-and-paste work you go from departments from emloyees again and again...
With SQL*Plus Commander, you make a query on departments table, view the results, browse (or filter) the data moving among them with a cursor, then select with the cursor the desidered row, and hit a key for query the employees related to that row (passing automatically the keycode as a parameter for the query from eployees) then go bak to the departments (upper level) with "Q" shurtcut.

SQL*Plus Commander
uses a text colored interface (mainframe style)
requires very low reources and is very fast
does not require any administratin right
is portable and does not make any change to your databases
does not suport mouse (sorry, only keyboard. Use mouse just to select text and copy for other applications)

unfortunately, you have to make some configurations before using it, you should be a little skilled in linux command line and Oracle SQL*Plus

[Requirements]

Configuration

[spcmd.env]
[Oracle client check]
[spcmd.sh]
[spcmd.def]

Navigation

[Interface]
[Pages]
[Managing colors]