Hey Pandian Selvam!
How have you been? Do you know what you really want? Hehe.

SELECT ASCII('A') || ASCII('B') || ASCII('C') FROM DUAL

Have a great Day!





Please take a few minutes to provide feedback on the quality of service you received from our staff. The Department of Education values your feedback as a customer. Commissioner of Education Jeanine Blomberg is committed to continuously assessing and improving the level and quality of services provided to you.Simply use the link below. Thank you in advance for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]




-----Original Message-----
From: Pandian Selvam
[mailto:oracledba-ezmlmshield-x3868727.[Email address protected]
Sent: Tuesday, August 07, 2007 2:13 AM
To: LazyDBA Discussion
Subject: RE: String to ASCII conversion in Oracle 10g

Thanx

But i want to convert a String in to Ascii

like 'ABC' to ascii


-----Original Message-----
From: Vetri Bala
[mailto:oracledba-ezmlmshield-x4907260.[Email address protected]
Sent: Tuesday, August 07, 2007 1:12 PM
To: LazyDBA Discussion
Subject: RE: String to ASCII conversion in Oracle 10g


There is ascii function to convert string to ascii

Ex: select ascii('A') from dual

Hope you are searching for this only.

-----Original Message-----
From: Pandian Selvam
[mailto:oracledba-ezmlmshield-x56325191.[Email address protected]
Sent: Tuesday, August 07, 2007 8:53 AM
To: LazyDBA Discussion
Subject: String to ASCII conversion in Oracle 10g

Hi

Anyone help me to covert a string into ASCII format.

Thanks in advance


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html







---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

Oracle LazyDBA home page