Insert Value Error
Date: Tue, 08 Jul 2003 01:01:31 GMT
Message-ID: <MPG.1973e19d813d8f15989681_at_nntp.slnt.phub.net.cable.rogers.com>
Hello everyone.
I am a newbie to Oracle 8 so please be patient and thanks for your time.
The problem is the above mentioned error. I have two databases
successully created using SQL*Plus 8.03. They are as follows:
Create Table EMPLOYEES
Create Table DEPARTMENT
I then try to insert a record into the Employees table and received the
above mentioned error:
Insert into employees Values
I then decided to try to insert a record into the Department table and
received the exact same error. I have read on google.com since the
Employees table has a foreign key which references a primary key in the
(
FName VARCHAR(15) NOT NULL,
MINIT CHAR,
LName VARCHAR(15) NOT NULL,
SSN CHAR(9) NOT NULL,
BDATE CHAR(25),
Address VARCHAR(30),
Sex CHAR,
Salary DECIMAL(10,2),
SUPERSSN CHAR(9),
DNO INT,
Primary Key(SSN),
Foreign Key(SUPERSSN) REFERENCES EMPLOYEES(SSN),
Foreign Key(DNO) REFERENCES DEPARTMENT(DNUMBER)
);
(
DNAME VARCHAR(15) NOT NULL,
DNUMBER INT NOT NULL,
MGRSSN CHAR(9) NOT NULL,
MGRSTARTDATE CHAR(25),
Primary Key(DNUMBER),
Unique(DNAME),
Foreign Key(MGRSSN) References EMPLOYEES(SSN)
);
('John', 'B', 'Smith', '123456789', '1965-01-09', '731 Fondren,
Houston, TX', 'M', 30000, '33344555', 5);
Any help would be greatly appreciated.
Thanks again
Victor Received on Tue Jul 08 2003 - 03:01:31 CEST