Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> SQL newbie
Hallo, I have the following SQL for creating a table. If you can help
me sort out what is wrong I would helpfull.
create sequence testsequence;
create table testtable(a number primary key, b number
testsequence.nextval);
insert into testtable values (1034); insert into testtable values (1045); insert into testtable values (32);
The error that Oracle says is:
create table testtable(a number primary key, b number testsequence.nextval)
*