Member Avatar for rotten69

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"
  • 2 Contributors
  • 2 Replies
  • 162 Views
  • 3 Hours Discussion Span
  • Latest Post Latest Post by rotten69
Member Avatar for urtrivedi

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

Here query runs perfectly

Member Avatar for rotten69

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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.