Re: newbie: one file, multiple statements?

From: <vastroc_at_my-deja.com>
Date: 2000/07/31
Message-ID: <8m4vqv$lan$1@nnrp1.deja.com>#1/1

In article <R%kh5.1647
$7F2.119447_at_news3.cableinet.net>,
"Russell England" <russ_at_css2.com> wrote:
> Can I put a bunch of create table statements
into a single .sql file and run
> it from sqlplus?
>
> I've tried separating each statement with a sem-
colon (;) but it says
> unrecognised character.
>
> Thanks in advance
>
> Russ
>
>

Yes, you can combine several commands in a .sql file and run it from sqlplus. You are on the right track but you also have to include a / (slash) after your semicolon. Example : create tablea (.........);
/
create tableb (........);

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Jul 31 2000 - 00:00:00 CDT