Re: NEWBIE Question:DDL file

create table foo
(a number(1)
, b number(2)
)
/

create table bar
(a number(2)
, c number(4)
)
/

really should be all. Save it and start it with @<filename>

Hth,
Sybrand Bakker, Oracle DBA

<slbarnes_at_fit.edu> wrote in message
news:fa1bess47ke5r6vp4mvn97vv13d20ulkri_at_4ax.com...
> I've been able to create a text file that I can load into SQL+ and
> create "1" table after I use "run" from the menu for the statements
> loaded . I need to create a file that creates multiple tables. How
> do I do this?????? I get errors when I have create table and the
> related info. .in the file for the second time when I'm trying to
> create the second table. Is there a special syntax I need to follow?
>
> Thanks for any help
> SB
Received on Sun Apr 02 2000 - 15:39:40 CDT