Bastion Bastion - 1 year ago 66
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’

Can someone tell me what is wrong with my command?

Answer Source

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.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download