Removing REM INSERTING and SET DEFINE OFF from SQLcl Output
2
votes
0
answers
3267
views
I ran below script to get data from Oracle, and then load to Postgres with psql.
SET SQLFORMAT INSERT
SET FEEDBACK OFF
SET TERMOUT OFF
SPOOL asset_file.sql
SELECT * FROM FINANCE.ASSET;
SPOOL OFF
QUIT
However in SQLcl output, the first few lines are:
REM INSERTING into finance.asset
SET DEFINE OFF;
Insert into finance.asset( ...
which results in error because the first two lines not recognized by Postgres, using psql client with -f option.
What are options that I can further put in SQLcl script to ensure those first two lines not being output? I don't want
REM INSERTING
and SET DEFINE ..
in the output.
Asked by idazuwaika
(121 rep)
Sep 20, 2018, 05:31 PM
Last activity: Sep 20, 2018, 06:32 PM
Last activity: Sep 20, 2018, 06:32 PM