How to extract a delimited file? 1

[prismtx]

I need to extract data from about a dozen tables to pipe-delimited files. Some of these have 70-80 fields in them. I want to extract all fields from the selected records. Is there an easier way to insert the delimiters other than

Select field1, '|', field2, '|', .... field75 from table1
where status = 'E'

 

[Turkbear]

Hi,
Check out the SqlPLus option

SET COLSEP = '|'

( check for exact one, my manual is not with me)





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[prismtx]

Thanks Turkbear. I knew there was a way, but could not find the way to set it. It worked perfect.

The syntax was:

SET COLSEP '|' no equals sign