To export SQL results to Excel using SQLPLUS, you have to follow the following steps Step 1: Login into data-base using SQL PLUS Ste...
To export SQL results to Excel using SQLPLUS, you have to follow the following steps
Step 1: Login into data-base using SQL PLUS
Step 2: Set mark-up using command “ SET MARKUP HTML ON”
Step 3: Spool the output to a file “SPOOL C:\TEMP\MYOUTPUT.XLS”
Step 4: Execute your SQL QUERY
Step 5: Set the Spool off
Step 6: To view the output open the output XLS file