SQL Language (MOSC)

MOSC Banner

How to use tab delimited in column separation in SQL*Plus script that is to run in concurrent proces

edited Apr 17, 2017 12:34PM in SQL Language (MOSC) 9 commentsAnswered ✓

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:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center