Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intelligent Information And Database Systems 12th Asian Conference ACIIDS 2020 Phuket Thailand March 23 26 2020 Proceedings

Authors: Pawel Sitek ,Marcin Pietranik ,Marek Krotkiewicz ,Chutimet Srinilta

1st Edition

9811533792, 978-9811533792

More Books

Students also viewed these Databases questions