Funny one this - I've got a load of scripts from a supplier with
create table commands. They error as there's a blank line in front of
constraint clauses. Is there a way of making them work- without editing the
whole lot?
Don't really want to edit delivered product scripts.
Oracle 18c Redhat 7.
CREATE TABLE FREDCASTER
(
ID NUMBER NOT NULL,
NAME VARCHAR2 (50) NOT NULL,
EMAIL_ADDRESS VARCHAR2 (1000),
EMAIL_ADDRESS2 VARCHAR2 (1000),
SEND_UNMATCHED_EMAIL VARCHAR2 (1),
SALUTATION_ADDRESS VARCHAR2 (100),
LAST_LOGIN DATE,
FREDCAST_GRP_ID NUMBER NOT NULL,
EXTERNAL_BRDCST_ID VARCHAR2 (50),
SFTP_USER VARCHAR2 (100),
LOG_DIRECTORY VARCHAR2 (100),
LOGS_ENABLED VARCHAR2 (1) NOT NULL,
CONSTRAINT CHECK_ENABLED CHECK (LOGS_ENABLED IN ('Y', 'N')),
CONSTRAINT FREDCASTER_PK PRIMARY KEY (ID) USING INDEX TABLESPACE
TRANS_TAB
) TABLESPACE TRANS_TAB;
COMMIT;
Best Wishes
Howard A. Latham