-
Hi ,
Does any one know how to generate TAB delimited files using sql.
Thanks in advance
Jagdish.
-
it worked fine for me if you just do something like this
select column1 || '<insert tab here>' || column2 || '<insert tab here>' || column3 from table where condition;
if that doesn't work for you for some reason, you could always delimit it with some other character like a comma, then search and replace the commas with tabs with a small script.
-
You could use colsep in sqlplus:
set colsep '<insert tab here>'
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
|