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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!