Thanks Ralf

-----Original Message-----
From: Ralf
[mailto:oracledba-ezmlmshield-x79911429.[Email address protected]
Sent: Tuesday, August 07, 2007 2:41 PM
To: LazyDBA Discussion
Subject: RE: String to ASCII conversion in Oracle 10g


Hai da, Pandian!!

Try...

"select dump( 'ABC') from dual"

:-))


______________________________

Ralf Stecher

OCP Database Administrator
Bioinformatics
Cellzome AG
Meyerhofstrasse 1
69117 Heidelberg



"Pandian Selvam " <oracledba-ezmlmshield-x3868727.[Email address protected]

08/07/2007 08:13 AM

To
"LazyDBA Discussion" <[Email address protected]
cc

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




---------------------------------------------------------------------
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