OraFAQ Forum: SQL & PL/SQL » Help with how to do

Home » SQL & PL/SQL » SQL & PL/SQL » Help with how to do (oracle 12c)

Sun, 20 December 2015 22:02

vs140580
Messages: 70
Registered: December 2015

Member

If I have a table with 4 columns like in some of my pervious posts how can I use sql developer to export all data in a table to csv file

Sun, 20 December 2015 22:06

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

sqlplus scott/tiger
set colsep ,
spool emp.csv
select * from emp;
spool off
exit

Sun, 20 December 2015 22:08

vs140580
Messages: 70
Registered: December 2015

Member

Thank you

Previous Topic:	Please help for Resolving issue with utl_file
Next Topic:	help to correct syntax error

Goto Forum:

]

Current Time: Sat Jun 27 07:52:59 CDT 2026