Re: blank lines in create table script

There is also the way of the masters(TM):

perl  -pe 'while(<>) { next if /^\s*$/; print; }'<howard.sql  >/tmp/howard.sql

The file "howard.sql" is the "create table" you sent.

On 12/3/19 10:59 AM, Howard Latham wrote:
>
> Brilliant thanks !!
>
>
> Howard A. Latham
>
>
>
>
> On Tue, 3 Dec 2019 at 15:55, Noveljic Nenad
> <nenad.noveljic_at_vontobel.com <mailto:nenad.noveljic_at_vontobel.com>> wrote:
>
> Could you try “set sqlblanklines on” in sqlplus ?
>
> Best regards,
>
> Nenad
>
> https://nenadnoveljic.com/blog/
>
> *From:*oracle-l-bounce_at_freelists.org
> <mailto:oracle-l-bounce_at_freelists.org>
> <oracle-l-bounce_at_freelists.org
> <mailto:oracle-l-bounce_at_freelists.org>> *On Behalf Of *Howard Latham
> *Sent:* Dienstag, 3. Dezember 2019 16:50
> *To:* ORACLE-L <oracle-l_at_freelists.org
> <mailto:oracle-l_at_freelists.org>>
> *Subject:* blank lines in create table script
>
> 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
>
> ____________________________________________________
>
> Please consider the environment before printing this e-mail.
>
> Bitte denken Sie an die Umwelt, bevor Sie dieses E-Mail drucken.
>
>
> Important Notice
> This message is intended only for the individual named. It may
> contain confidential or privileged information. If you are not the
> named addressee you should in particular not disseminate,
> distribute, modify or copy this e-mail. Please notify the sender
> immediately by e-mail, if you have received this message by
> mistake and delete it from your system.
> Without prejudice to any contractual agreements between you and us
> which shall prevail in any case, we take it as your authorization
> to correspond with you by e-mail if you send us messages by
> e-mail. However, we reserve the right not to execute orders and
> instructions transmitted by e-mail at any time and without further
> explanation.
> E-mail transmission may not be secure or error-free as information
> could be intercepted, corrupted, lost, destroyed, arrive late or
> incomplete. Also processing of incoming e-mails cannot be
> guaranteed. All liability of Vontobel Holding Ltd. and any of its
> affiliates (hereinafter collectively referred to as "Vontobel
> Group") for any damages resulting from e-mail use is excluded. You
> are advised that urgent and time sensitive messages should not be
> sent by e-mail and if verification is required please request a
> printed version. Please note that all e-mail communications to and
> from the Vontobel Group are subject to electronic storage and
> review by Vontobel Group. Unless stated to the contrary and
> without prejudice to any contractual agreements between you and
> Vontobel Group which shall prevail in any case,
> e-mail-communication is for informational purposes only and is not
> intended as an offer or solicitation for the purchase or sale of
> any financial instrument or as an official confirmation of any
> transaction.
> The legal basis for the processing of your personal data is the
> legitimate interest to develop a commercial relationship with you,
> as well as your consent to forward you commercial communications.
> You can exercise, at any time and under the terms established
> under current regulation, your rights. If you prefer not to
> receive any further communications, please contact your client
> relationship manager if you are a client of Vontobel Group or
> notify the sender. Please note for an exact reference to the
> affected group entity the corporate e-mail signature. For further
> information about data privacy at Vontobel Group please consult
> www.vontobel.com <https://www.vontobel.com>.
>

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217


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