Home » SQL & PL/SQL » SQL & PL/SQL » Help with how to do (oracle 12c)
Help with how to do [message #646159] Sun, 20 December 2015 22:02 Go to next message
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

Report message to a moderator

Re: Help with how to do [message #646160 is a reply to message #646159] Sun, 20 December 2015 22:06 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
sqlplus scott/tiger
set colsep ,
spool emp.csv
select * from emp;
spool off
exit

Report message to a moderator

Re: Help with how to do [message #646161 is a reply to message #646160] Sun, 20 December 2015 22:08 Go to previous message
vs140580
Messages: 70
Registered: December 2015
Member
Thank you

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 12:16:50 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.