Tab Delimited

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 ''