blank lines in create table script

From: Howard Latham <howard.latham_at_gmail.com>
Date: Tue, 3 Dec 2019 15:50:24 +0000
Message-ID: <CAPCNhx0Spb3HrRwnemJTioc2Dsv3gkOMnQwSo3kJ4NH299HxjA_at_mail.gmail.com>

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

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Dec 03 2019 - 16:50:24 CET