| string leteral updation [message #607805] |
Wed, 12 February 2014 03:50  |
 |
sunilreddy
Messages: 37
Registered: September 2011
Location: Hyderabad
|
Member |
|
|
Hi All,
i want to execute the below statement in plsql code , can any one help me on this.
UPDATE emp
SET instruction = 'Don't go away, we'll get back to you'
where emp_id = 'Sunil';
when this statement comes to execute geting invalid sql statement exception. please help me on this.
|
|
|
|
|
|
|
|
|
|
| Re: string leteral updation [message #607810 is a reply to message #607805] |
Wed, 12 February 2014 03:58  |
 |
Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
It is about "we'll" which is located within single quotes (that terminate the whole sentence). There are a few options to fix it, such as
SQL> SELECT
2 'we''ll' two_single_quotes,
3 q'[we'll]' quoting_character_literals,
4 'we' || chr(39) ||'ll' single_quote_CHR
5 FROM DUAL;
TWO_S QUOTI SINGL
----- ----- -----
we'll we'll we'll
SQL>
Pick one.
[Updated on: Wed, 12 February 2014 03:58] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
