Creando una salida de formato html desde SQL*Plus 9i o superior

column MACHINE format a30

column IP_ADDRESS format a15

set linesize 200

SET markup HTML on

spool d:\tmp\test1.html;

select sid, serial#, username, process, machine, sys_context('userenv','ip_address') IP_ADDRESS

from v$session

where machine='MORFEO\T1_RVARGAS';

spool off;

SET markup HTML off