How you can export SQL results to Excel using SQLPLUS?

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

COMMENTS

Name

PeopleSoft HCM HRMS Interview Questions PeopleSoft HRMS Interview Questions PeopleSoft Interview Questions
false
ltr
item
PeopleSoft Online Training: How you can export SQL results to Excel using SQLPLUS?
How you can export SQL results to Excel using SQLPLUS?
PeopleSoft Online Training
https://peoplesoftonlinelearning.blogspot.com/2016/11/how-you-can-export-sql-results-to-excel.html
https://peoplesoftonlinelearning.blogspot.com/
https://peoplesoftonlinelearning.blogspot.com/
https://peoplesoftonlinelearning.blogspot.com/2016/11/how-you-can-export-sql-results-to-excel.html
true
8010478567507321031
UTF-8
Not found any posts VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES POSTS View All RECOMMENDED FOR YOU LABEL ARCHIVE SEARCH ALL POSTS Not found any post match with your request Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS CONTENT IS PREMIUM Please share to unlock Copy All Code Select All Code All codes were copied to your clipboard Can not copy the codes / texts, please press [CTRL]+[C] (or CMD+C with Mac) to copy