a very strange but simple question [message #9440] |
Mon, 10 November 2003 20:39 |
peng
Messages: 6 Registered: October 2002
|
Junior Member |
|
|
hi,erveryone
i met a strange question :how can i get the ascii value of the "'" in sql*plus by using ascii function.
when i use
SQL> select ascii(''') from dual;
ERROR:
ORA-01756: 括号内的字符串没有正确结束
who can help me
|
|
|
Re: a very strange but simple question [message #9441 is a reply to message #9440] |
Mon, 10 November 2003 21:56 |
Rajarshi Dasgupta
Messages: 52 Registered: October 2001
|
Member |
|
|
Try this...
select ascii('''') from dual;
To denote a single quote (') in SQL and or PL/SQL you need to write ''''.
Say if you want to show 'peng' then you need to write like ...
Select '''' || 'peng' || '''' From dual
OR you may write like...
Select '''peng''' From dual
|
|
|
|