How to use tab delimited in column separation in SQL*Plus script that is to run in concurrent proces
Hello there,
I am trying to create a script by using SQL*Plus that is going to be run in Oracle concurrent process. I need to separate the columns in the report by tab, so I used the following command according to user's guide and reference for SQL*Plus:
SET COLSEP "&TAB"
Of course it won't work :-) since the guide assumes everything is run under SQL*Plus environment, but not as a script. The error I got is because of usage of "&":
Enter value for tab: EXEC FND_CONC_STAT.COLLECT;
My question is: what is the correct command/code to use tab delimited column separation in SQL*Plus script that to be run in Oracle concurrent process. I actually tried this: