select
ascii(substr('PER MONTH',1,1)),
ascii(substr('PER MONTH',2,1)),
ascii(substr('PER MONTH',3,1)),
ascii(substr('PER MONTH',4,1)),
ascii(substr('PER MONTH',5,1)),
ascii(substr('PER MONTH',6,1)),
ascii(substr('PER MONTH',7,1)),
ascii(substr('PER MONTH',9,1))
from dual
Code to get ASCII codes of character appearing in Vendor Name
select ascii(substr(a.VENDOR_NAME,1,1)) from ap_suppliers a
where a.SEGMENT1 = 1
select chr(83) from dual
Thanks for Sharing this Issue! Usually our Company Copy Paste Data from Webs in Oracle Forms and their is always ASCII Issue occurring all the time
ReplyDelete