Thanks to everybody
I'm using below query to get the ASCII
select replace(Ltrim(Rtrim(substr(dump('ABC'),instr(dump(
'ABC'),':')+1))),',','') ascii from dual;
-----Original Message-----
From: Edwards Ed
[mailto:oracledba-ezmlmshield-x92038190.[Email address protected]
Sent: Tuesday, August 07, 2007 4:44 PM
To: LazyDBA Discussion
Subject: RE: String to ASCII conversion in Oracle 10g
Well, well, well!
It's Hrishikesh Ashok Vaidya! Hehe. How have you been? Oh my!
Phew! Outstanding! Hehe.
Have a great Day!
-----Original Message-----
From: Hrishikesh Ashok Vaidya
[mailto:oracledba-ezmlmshield-x99477363.[Email address protected]
Sent: Tuesday, August 07, 2007 4:41 AM
To: LazyDBA Discussion
Subject: RE: String to ASCII conversion in Oracle 10g
SQL> select substr(dump('abc'),instr(dump('abc'),':',1)+1) from dual;
SUBSTR(DU
---------
97,98,99
This is easy ....
Regards,
Hrishikesh Vaidya
________________________________________________________________________
_______________
Technical Architect
Infosys Technologies Ltd.
Cell# : +91-98224-94994
Direct : +91-20-39827821
MeetUs @ www.infosys.com
-----Original Message-----
From: Edwards Ed [mailto:oracledba-ezmlmshield-x95656445.[Email address
protected]
Sent: Tuesday, August 07, 2007 2:08 PM
To: LazyDBA Discussion
Subject: RE: String to ASCII conversion in Oracle 10g
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
---------------------------------------------------------------------
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
**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended
solely for the use of the addressee(s). If you are not the intended
recipient, please notify the sender by e-mail and delete the original
message. Further, you are not to copy, disclose, or distribute this
e-mail or its contents to any other person and any such actions are
unlawful. This e-mail may contain viruses. Infosys has taken every
reasonable precaution to minimize this risk, but is not liable for any
damage you may sustain as a result of any virus in this e-mail. You
should carry out your own virus checks before opening the e-mail or
attachment. Infosys reserves the right to monitor and review the content
of all messages sent to or from this e-mail address. Messages sent to or
from this e-mail address may be stored on the Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***
---------------------------------------------------------------------
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