NISCHAL's DBA WORLD

Thursday, June 18, 2009

Oracle table to html file

$sqlplus -S -M "HTML ON TABLE 'BORDER="2"'" username@Ora10g @script.sql>filename.html
ex: - where script.sql contains:
select col1, col2 from table_name;
exit
Posted by PVS VAMSI at 11:02 AM
Newer Post Older Post Home

Blog Archive

  • ►  2008 (23)
    • ►  April (4)
    • ►  May (4)
    • ►  June (12)
    • ►  July (1)
    • ►  August (2)
  • ▼  2009 (52)
    • ►  January (9)
    • ►  February (1)
    • ►  March (12)
    • ►  April (1)
    • ►  May (6)
    • ▼  June (3)
      • Oracle tables to Excel
      • Oracle table to html file
      • expdp - nfs mount point
    • ►  July (4)
    • ►  August (3)
    • ►  September (6)
    • ►  October (1)
    • ►  November (4)
    • ►  December (2)
  • ►  2010 (4)
    • ►  January (1)
    • ►  March (1)
    • ►  July (1)
    • ►  December (1)
  • ►  2011 (2)
    • ►  January (1)
    • ►  February (1)
  • ►  2012 (3)
    • ►  May (2)
    • ►  November (1)
  • ►  2014 (1)
    • ►  November (1)
Picture Window theme. Powered by Blogger.