Skip to Main Content

sqlcl 4.1.0.15.106.1020 sqlformat insert tries SCHEMA not SCHEMA.TABLE

berxApr 23 2015 — edited May 4 2015

without schema name I get a proper insert statement:

set sqlformat insert

select * from DUAL;

REM INSERTING into DUAL

SET DEFINE OFF;

Insert into DUAL (DUMMY) values ('X');

but

set sqlformat insert

select * from SYS.DUAL;

REM INSERTING into SYS

SET DEFINE OFF;

Insert into SYS (DUMMY) values ('X');

which does not make really sense?

Martin

Comments
Post Details
Added on Apr 23 2015
2 comments
558 views