I have the following table but when I insert some values, the program displays an error message it says “(101,’Smith’,30000)
ERROR at line 2: ORA-01438: value larger than specified precision allows for this column”
Here are the table and insert value:
CREATE TABLE physican(
phys_Ref_no NUMBER(3) NOT NULL,
phys_name VARCHAR2(6),
phys_salary NUMBER(5,2),
PRIMARY KEY (phys_Ref_no));
INSERT INTO physician VALUES
(101,’Smith’,30000);
Help me please.
