Enhance Req.: "SHOW ALL" to show all command window settings done via SET

[Bernhard S]

I'd suggest in Command Window to have a command like "SHOW ALL" in SQL*Plus, showing all the settings defined via SET. Currently it's impossible to view your current setting i.e. for DEFINE. You can only see the following 7 settings underneath the Command Windows:
ECH = ECHO
TRM = TERMOUT
FDB = FEEDBACK
VER = VERIFY
APR = AUTOPRINT
HDG = HEADING
TMG = TIMING

All the following ones are all missing though:
COLSEP
CONCAT
DEFINE
ESCAPE
LONG
NUMWIDTH
PAGESIZE
PROMPT
SCAN
SPOOLDIRECTORY

I guess it would also make sense to define defaults for those settings in the PL/SQL preferences.
You can already set them now via login.sql, I guess.
BTW: This needs to be documented as well in the manual, which currently doesn't seem to be the case.

 

[Marco Kalter]

I have added this to the list of enhancement requests.