Blogroll

Get a website with Godaddy


Logo designer Fiverr Frelancer

Wednesday, September 3, 2014

How to export data from SQLplus into file

Hi, below are the guide on how to go about this trick...


Simple text
spool <filename> create;
<statement(s)>
spool off;

HTML
set markup html on
spool <filename> create;
<statement(s)>
spool off;
set markup html off

For Excel export :
http://stackoverflow.com/questions/6017863/create-an-excel-spreadsheet-from-a-oracle-database



No comments:

Post a Comment

Amazon store

alidropship plugin

alidropship plugin
alidropship plugin

Total Pageviews

About