Question: I created a table rsd_customer with a coloum rsd_customerPhoneNum. However, when i went to populate the table, it keeps on saying column rsd_customerPhoneNum is an

I created a table rsd_customer with a coloum rsd_customerPhoneNum. However, when i went to populate the table, it keeps on saying column rsd_customerPhoneNum is an invalid identifer despite any restrictions on it. What am I doing wrong here?

CREATE TABLE rsd_customer ( rsd_customerID INT PRIMARY KEY, rsd_customerLastName VARCHAR2(25) NOT NULL, rsd_customerFirstName VARCHAR2(20), rsd_customerCity VARCHAR2(25), rsd_customerState VARCHAR2(2), rsd_customerZIP VARCHAR2(10), rsd_customerEmail VARCHAR2(25) NOT NULL, rsd_customerPhoneNum VARCHAR2(12) ) ;

The select statement is: INSERT INTO rsd_customer ( customerID, customerLastName, customerFirstName, customerCity, customerState, customerZIP, customerEmail, customerPhoneNum ) VALUES (1, Alexander, Michael, Highland Heights, KY, 41076, alexander@yahoo.com, NULL );

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!