I am working o the DML Practice assignment and have created all tables and enter

Question

I am working o the DML Practice assignment and have created all tables and entered all rows in the tables. I am trying to change Wendy's record by entering the following commands in SQL Plus and cannot figure out what I am doing wrong. UPDATE Customer_DML Set Telephone='2155552000', DateOFBirth='13-Jun-1978' WHERE CustomerNumber='123456789012' ; I keep getting Error at line 4 ORA-01747 :invalid user.table.column, table.column, or column specification. Line 4 is my where statement. I have looked up the error message and update statements and still can not figure out what I am doing wrong? I did a Select* statement and can see the original information in my table is correct. There seems to be the same problem with all of my Where clauses. Can you help?

Explanation / Answer

Answer:

UPDATE Customer_DML Set Telephone='2155552000', DateOFBirth='13-Jun-1978' WHERE CustomerNumber='123456789012' ; In the given query remove quotes for the integer values for attribute values and execute the query as below :

UPDATE Customer_DML Set Telephone=2155552000,DateOFBirth='13-Jun-1978' WHERE CustomerNumber=123456789012;

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.