-
Can a sql statement be used to generate a comma delimited file in Oracle?
This is pretty urgent.
Thanks
-
You can do something like this:
> desc t1
Name Null? Type
------------------------------- -------- ----
A VARCHAR2(10)
B VARCHAR2(10)
C VARCHAR2(10)
> select a || ',' || b || ',' || c from t1;
A||','||B||','||C
--------------------------------
a1,a2,a3
b1,b2,b3
c1,c2,c3
You could spool the output to a file.
--
Paul
-
Or you can "SET COLSEP ," in SQL*Plus and just SELECT * FROM ...
Ales
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|