User using Automation Designer to execute SQL files and to export them into text file. How to control the output format of text generated, such as columns heading and delimiter characters?
The format of these files is controlled by Oracle commands such as "SET COLSEP |" and "SET PAGESIZE 0". Place such commands followed by a semicolon inside SQL files. Refer to Oracle documentation for further details.
