ORA-00913: too many values Error (Even though I have checked my table and entries)

203 views Asked by At

Here's is the table :

create table Student(
    student_id char(6) primary key,
    name varchar(10) not null,
    department char(20),
    grade char(6),
    percentage smallint,
    contact_no char(12),
    address varchar(50)
 );

This is what I'm inserting :

insert into Student
values ('ST-01','Zain','coe','A+',74,'9999777865','New Delhi');

Why ORA-00913: too many values error when I'm not inserting extra values ?

0

There are 0 answers