Bastion Bastion - 1 month ago 6
SQL Question

SQL UPDATE with two WHERE conditions

I can't find the error with my SQL command. I keep getting "ORA-01756: quoted string not properly terminated"

UPDATE Customers1
SET CUST_ADDRESS=’57 Jump str’
WHERE CUST_CITY=’Los Angeles’
AND CUST_STATE=’CA’;


Can someone tell me what is wrong with my command?

Answer

This may happen when your quotes are not straight. Ensure that they are properly formatted. Sometimes when you copy and paste it turns out the way that yours shows, which wouldn't run properly.

Comments