|
|
|
|
|
Re: Single quote issue in oracle [message #607920 is a reply to message #607918] |
Thu, 13 February 2014 08:26 |
|
mist598
Messages: 1195 Registered: February 2013 Location: Hyderabad
|
Senior Member |
|
|
SQL> DECLARE
2 qt VARCHAR2(10):='''';
3 p_type VARCHAR2(60):='~!@#$%^&*()-=_+[]\{}|;'':",./<>?';
4 lv_type VARCHAR2(60);
5 begin
6 lv_type :=qt||p_type||qt;
7 dbms_output.put_line( lv_type );
8 end;
9 /
'~!@#$%^&*()-=_+[]\{}|;':",./<>?'
PL/SQL procedure successfully completed.
I think one correct?
Your expected this one ~!@#$%^&*()-=_+[]\{}|;':",./<>?
[Updated on: Thu, 13 February 2014 08:45] Report message to a moderator
|
|
|