Oracle DBA and beyond; these are practical tips for day to day DBA operation and maintenance; a place where you would come to look for a quick fix for a burning situation. I hope that by sharing all these, we all will become better in what we do. And on the way, I hope to save you some sweat :-)
Friday, 26 August 2016
How to determine the ascii value of a specific character within a row?
How to determine the ascii value of a specific character within a row?
Let's say we are searching for the character § inside the DB.
SQL> select dump('§') from dual;
DUMP('§')
---------------------
Typ=96 Len=2: 194,167
SQL> select * from k where col1 like '%'||chr(194)||'%'||chr(167)||'%';
COL1
--------------------------------------------------------------------------------
§
Thanks to the site below:
https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:2143700800346224648
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment