On May 28, 9:30 am, Alex Jakovenko <alex.jakove...@gmail.com> wrote:
> I need to update varchar field with a value that ends with '\' symbol.
> How this could be done?
>
> UPDATE my_table SET password = 'FsXqa\' WHERE user_id = 1;
>
> It seems that '\' terminates closing single quote. How can I terminate
> '\' itself?
>
> TIA
It could be that your oracle server has changed the default escape
character. try escaping with an additional backslash.
Also are you sure the problem is with oracle. What client or from
which programming language are you entering the abovementioned query?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---