Question: how to export data from oracle table to excel file using sqlplus?
Answer: Step 1: Login into database using SQL PLUS. Step 2: Set markup using below command. Step 3: Spool the output to a file. Step 4: Run your SQL Query. Step 5: Set the Spool Off. Step 6: Open the output XLS file to view the output.