Question: Help! I keep getting the same error message whenever I try to enter data into this table: ERROR at line 2: ORA-01858: a non-numeric character
Help!
I keep getting the same error message whenever I try to enter data into this table:
ERROR at line 2: ORA-01858: a non-numeric character was found where a numeric was expected
What is wrong with this table?
CREATE TABLE CLASS1
(C_NAME varCHAR(7); Primary Key,
C_TIME TIMEstamp(6);
F_NAME CHAR(6);
C_ROOM varCHAR(5);
SEMESTER varCHAR(6);)
INSERT INTO CLASS1 VALUES
('INSS300', 'M5:30', 'DWIGHT', '219BC', 'FALL11');
INSERT INTO FACULTY1 VALUES
('INSS300', 'T5:30', 'KEEN', '216BC', 'FALL11');
INSERT INTO FACULTY1 VALUES ('MKT300', 'M5:30', 'LEE', '112BC', 'SP11');
INSERT INTO FACULTY1 VALUES ('MKT300', 'W5:30', 'LEE', '112BC', 'SP11');
INSERT INTO FACULTY1 VALUES ('INSS421', 'T5:30', 'CORY', '212BC', 'FALL11');
INSERT INTO FACULTY1 VALUES ('FIN300', 'TH5:30', 'KEEN', '219BC', 'FALL11');
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
