Some tips for sqlplus

1) Display current setting
SQL> show linesize
linesize 100

SQL> show all
...


2) Improve formatting
set linesize 120
set pagesize 20
column somestring format a30
column someint format 999,999,999
column somefloat format 999,999,999.99


3) Show database initialization parameters
SQL> set linesize 150
SQL> column NAME_COL_PLUS_SHOW_PARAM format a35
SQL> column VALUE_COL_PLUS_SHOW_PARAM format a35
SQL> show parameters


4) Current definitions
SQL> define
...
SQL> define _EDITOR="vi"


5) Generate HTML
set markup HTML on
spool index.html
select * from tab;
spool off
set markup HTML off