6
Export SQL Results To Excel Using SQLPLUS
Here is quick tip on how to easily export SQL results into an excel file. Step 1: Login into database using SQL PLUS Step 2: Set markup using below command SET MARKUP HTML ON Step 3: Spool the output to a file. SPOOL C:\TEMP\MYOUTPUT.XLS Step 4: Run your SQL Query SQL QUERY Step 5: Set […]
Continue readingHow to Change SQL Plus Settings
I do not like the default size of the SQL *Plus window and prefer to customize it as per my preference. You can also do the same by changing the default parameters of SQL Plus. You can perform the following changing in SQL *Plus: Change cursor size Change command history Change fonts Change layout Change […]
Continue reading