User, date Message
Written by rameshkoratkar@gmail.com
2 years ago
Category: General
1 posts since Sun, 02 Sep 12
I have created table with structure as below,
create table student(sno number(2),sname varchar(20) not null,sfee number(7,2) check(sfee>1000),sloc varchar(20)not null);
I tried to add primary key after creating table as below,
alter table student add consstraint st_pk_sno primary key(sno);
But it is giving error as "INVALID DATATYPE"
please somebody help me or somebody recommend something to me.
Written by ansgar
2 years ago
5015 posts since Fri, 07 Apr 06
Is that posted by accident or is that a real question? This is a HeidiSQL forum, and Oracle is not supported at all by HeidiSQL.

Please login to leave a reply, or register at first.