Home » SQL & PL/SQL » SQL & PL/SQL » create a csv ?
create a csv ? [message #18725] Tue, 12 February 2002 07:34 Go to next message
krahuman
Messages: 18
Registered: January 2002
Junior Member
how can i generate a csv file for a ora 8i table ?
using utl_file package or some other
example:

mydable(field1,field2,field3);

the file should be like

value11,value12,value13
value21,value22,value23
value31,value32,value33
value41,value42,value43
value51,value52,value53
value61,value62,value63

kaleel

Report message to a moderator

Re: create a csv ? [message #18726 is a reply to message #18725] Tue, 12 February 2002 09:29 Go to previous message
Jon
Messages: 483
Registered: May 2001
Senior Member
http://asktom.oracle.com/pls/ask/f?p=4950:8:496357::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:95212348059,%7Bcsv%7D

If the link doesn't work because of wrapping, go to asktom.oracle.com and search on CSV

Report message to a moderator

Previous Topic: One URGENT problem with SQL
Next Topic: table exists .. or not
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 09:37:18 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.