Any one has any suggestion how to generate a TAB delimited file.
try using the sql worksheet:
select '234'||chr(9)||'234' from dual;
you'll get a tab-delimited section. just cut & paste.
It is better to ask and appear ignorant, than to remain silent and remain ignorant.
Oracle OCP DBA 9i,
C++, Java developer
That is right. CHR() is a function will return the charactor with the ascii value of integer. U can add char(10) just after the "TAB" character to indicate the new line.
go to [url]http://members.tripod.com/~plangford/index.html[/url]
to see all the ascii table.
Click Here to Expand Forum to Full Width