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"
Jump to Postwhat error does it return (may be you can see error number also)
Here query runs perfectly
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!!"
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.