Simple question.. Tables 1

[hyperdaz]

Hows the simplist way for me to create three tables...??

create table ctn_details

ctn varchar2(24 not null
ban number(9)
connection_date date
disconnection_date date
disconnection_reason varchar2(100)


Plus many many more..

create table c.o.v
ctn varchar2(24) not null
plus more

create table c.o.a
attribute_type varchar2(10)

plus more

 

[SantaMufasa]

Hyper,

Your code should run fine (provided the "plus more..." stuff is syntactically correct), if you fix these problems:
1) Don't leave blank lines in your SQL code.
2) Separate your column definitions with commas.
3) Don't name your tables with '.'s; use '_' to provide visual spacing or name-component separators.
4) Cause your SQL commands to execute with either a '/' on a line of its own or with ';'.

Mufasa
(aka Dave of Sandy, Utah, USA @ 11:03 (22Jan04) GMT, 04:03 (22Jan04) Mountain Time)

 

[hyperdaz]

thanks Mufasa

I did it through the gui after much looking..

one more question
ban number(14,3)

what is the (14,3) or more importantly is the ,3 the scare??
???? etc

thanks

 

[amortillaro]

14 digits, where 3 of them are decimals
###########.###