Hi everyone,

I'm sure the update statement is well-written but for some reason Oracle sql command line is refusing to execute it.

UPDATE myTable SET country = 'Aus' WHERE username = '"martin"';

// I know you can see single quote and double-quote as well. Well, names were inserted into the table with double-quote ==> as "john"

what error does it return (may be you can see error number also)

Here query runs perfectly

I solved it. I don't know how case-sensetive oracle is. I'm sure I had the same command this morning but it gave an error message "the line is not properly ended!!"

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.