On May 28, 2: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
I don't have that problem:
SQL> create table my_table(
2 user_id number,
3 username varchar2(30),
4 password varchar2(30)
5 );
Table created.
SQL> insert into my_table
2 values(1, 'Snork', 'Splav');
1 row created.
SQL> commit;
Commit complete.
SQL> UPDATE my_table SET password = 'FsXqa\' WHERE user_id = 1;
1 row updated.
SQL> commit;
Commit complete.
SQL> select * From my_table;
USER_ID USERNAME PASSWORD
---------- ------------------------------
------------------------------
1 Snork FsXqa\
SQL>
Which release of Oracle are you using? The above was run on Oracle
11.1.0.6.0.
David Fitzjarrell
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
