Home » SQL & PL/SQL » SQL & PL/SQL » Create csv from table or query
Create csv from table or query [message #235080] Fri, 04 May 2007 00:42 Go to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
If you want to create a comma-separated file from a query or a table to load in Excel, check this link.

[Updated on: Fri, 04 May 2007 00:43]

Report message to a moderator

Re: Create csv from table or query [message #235084 is a reply to message #235080] Fri, 04 May 2007 00:47 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Hm, apparently, it needs some tweaking. Null columns are not handled well..
Re: Create csv from table or query [message #235270 is a reply to message #235084] Fri, 04 May 2007 10:38 Go to previous messageGo to next message
joy_division
Messages: 4643
Registered: February 2005
Location: East Coast USA
Senior Member
And I am having a hard time with the tick marks and brackets not pasting properly.

I don't have tick marks that look like that on my keyboard.
Re: Create csv from table or query [message #235279 is a reply to message #235080] Fri, 04 May 2007 12:17 Go to previous message
Bill B
Messages: 1484
Registered: December 2004
Senior Member
search for dump_csv at http://asktom.oracle.com
Previous Topic: without colum name
Next Topic: POSITIONAL HIERARCHY
Goto Forum:
  


Current Time: Thu Dec 08 20:00:45 CST 2016

Total time taken to generate the page: 0.08706 seconds