How to execute .sql file using another .sql file in Oracle?

Question

I try to start cr_tb.sql file using another start.sql file and get an error unknown command beginning pid number... The strange thing is that when I simply copy paste the cr_tb.sql content into the SQL*Plus, it executes perfectly.

What am I doing wrong? (I have posted the dropbox links)

Seems like you have posted the same link for both files mate. — Bren
– Bren, Commented Aug 17, 2013 at 21:17

Nick Krasnov · Accepted Answer · 2013-08-18 07:56:52Z

4

The root of the problem lays in the create table frclubs statement. There are blank lines in

the table definition:

create table frclubs
(
    -- here they are

pid number(2) not null,
clubid number(2) not null,
constraint cPIDCLUBIDPK primary key(pid,clubid),
constraint fPIDFK foreign key(pid) references friends(pid),
constraint fCLUBIDFK foreign key(clubid) references clubs(clubid)
);

You have two choices:

Remove blank lines in the create table frclubs DDL statement;
Allow SQL*PLUS ignore blank lines in the script issuing SET SQLBLANKLINES ON command.

edited Aug 18, 2013 at 7:56

answered Aug 17, 2013 at 21:50

Nick Krasnov

27.3k6 gold badges66 silver badges81 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Udit Mishra Over a year ago

Can we conditionally execute statement? Like - DECLARE counter int; BEGIN SELECT COUNT(*) INTO counter FROM user_tables WHERE table_name = UPPER('OOLD_SFWID_CHG_LOG_TAB_DESC'); IF counter = 1 THEN @C:\Users\umishra\Desktop\GE-5560\secondfile; END IF; END; / But it does not work

Collectives™ on Stack Overflow

How to execute .sql file using another .sql file in Oracle?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related