Friday, August 15, 2008

HTML Output from sqlplus

# Use sqlplus to produce nicely formatted output

set markup html on
spool c:\system_users.html
select username, default_tablespace from dba_users where default_tablespace = 'SYSTEM';
spool off;
set markup html off