mm

This is Vinod Kumar having 15+ years of experience as Oracle DBA having exposure to RAC, Dataguard, RMAN,GoldenGate, DB Upgrades ,Hadoop. Looking forward to sharpen my skill set and adapt new things. Worked for various industries like Banking, financial, Telecom, Product based companies and retail etc.

Share this post

Generate output in HTML

in Oracle DB Admin, Oracle Production Support Scripts, Partitions/Shell Script
Share via:
Post Views: 0

set linesize 200
set pagesize 500

spool /tmp/Oct29.html
set markup html on
set numwidth 40

select * from emp;

set long 100000
select sql_id,sql_text from DBA_HIST_SQLTEXT where sql_id in (select sql_id from v$session);

spool off

Share via:
Note: Please test scripts in Non Prod before trying in Production.
1 Star2 Stars3 Stars4 Stars5 Stars (10 votes, average: 5.00 out of 5)
Loading...

You might also like...

One thought on “Generate output in HTML”

Add Comment