Column not allowed here?
561112Feb 10 2007 — edited Feb 10 2007I just installed Oracle 10g. I made a table
CREATE TABLE Employee (
fname VARCHAR(15) NOT NULL,
minit CHAR,
lname VARCHAR(15) NOT NULL,
ssn CHAR(9) NOT NULL,
bdate DATE,
address VARCHAR(30),
sex CHAR,
salary DECIMAL(10,2),
super_ssn CHAR(9),
dno INT NOT NULL,
PRIMARY KEY (ssn));
Then I tried to insert into the table:
INSERT INTO Employee VALUES ("John","B","Smith","123456789","09-JAN-1965","731 Fondren, Houston, TX",M,30000,"333445555",5);
but for some reason the the "33344555" part is giving me an error that says "column not allowed here". I don't see anything wrong with the statement. Am I missing something?