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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started