Re: blank lines in create table script

Mladen,

it should be like this:
perl -ne '/^\s*$/||print'<howard.sql >tmp.sql

or with -i.bak:
 perl -i.bak -ne '/^\s*$/||print' *.sql

On Tue, Dec 3, 2019 at 7:08 PM Mladen Gogala <gogala.mladen_at_gmail.com> wrote:

> 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>
> wrote:
>
>> Could you try “set sqlblanklines on” in sqlplus ?
>>
>> Best regards,
>>
>>
>>
>> Nenad
>>
>>
>>
>> https://nenadnoveljic.com/blog/
>>
>>
>>
>>
>>
>> *From:* oracle-l-bounce_at_freelists.org <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>
>> *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.
>>
> --
> Mladen Gogala
> Database Consultant
> Tel: (347) 321-1217
>
>

-- 
Best regards,
Sayan Malakshinov
Oracle performance tuning engineer
Oracle ACE Associate
http://orasql.org

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