var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: use single quote ascii value for display strings?
Hi i have small doubt
1. when we want to display string we display like this
select 'HI' from dual;
instead of single quote (apostrophe) before and after HI can i use ASCII value of single quote
like select 39HI39 from dual;
anypossibility is there for using ascii value instead of single quote.
Last edited by ramana554; 09-30-09 at
Sorry, I mean "NO"!
But I'm curious: what problem are you trying to overcome? If we understand that we may be able to suggest a different approach that will work. If it is that you are trying to write dynamic SQL with quotes in, do this:
v_sql := 'select ''HI'' from dual';
Well, sure, you can use ASCII values - you'd
concatenate them with the rest of the string:
However, you can not omit apostrophes:
SQL> select chr(39) ||'hello'|| chr(39) result from dual;
So, what is the problem, anyway?
SQL> select chr(39) ||hello|| chr(39) result from dual;
select chr(39) ||hello|| chr(39) result from dual
ERROR at line 1:
ORA-00904: "HELLO": invalid identifier