Newbie: datatype, sequence

Hi,

I am new to Oracle9i SQL and have a problem in choosing the correct datatype; I create the following table:

create table test (
id integer primary key,
name char(30),
adress char(40)
);

Now I would like to have "id" as a sequence. Which datatype should I use when I create the table? Integer like in my example above?

Thanks for your help,
Stefan Received on Wed Aug 14 2002 - 04:18:31 CDT