Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

find Extended ASCII Codes or Character Special on column oracle

gsflash80Jul 11 2012 — edited Jul 12 2012
Hi everyone, i'll want to use query for to find all character special and extended ASCII codes on column

i have tried this records:

select * from char_speciale

---------------------------

SURNAME NAME

SERPI!! GAB
SE£ GRA
ARA%%& sa
@dass dsadsa
ara€ ssa
gabriele dsa

-------------------------------------------------------------------------------------------------------------

select * from char_speciale
where regexp_like(surname, '('|| chr(33) || '|'
|| chr(37) || ')')

---------------------------------
SURNAME NAME

SERPI!! GAB
ARA%%& sa

-------------------------------------------------------------------------------------------------------------

select * from char_speciale
where regexp_like(surname,'[[:punct:]]');

--------------------------------
SURNAME NAME

SERPI!! GAB
SE£ GRA
ARA%%& sa
@dass dsadsa
ara€ ssa

-------------------------------------------------------------------------------------------------------------

select * from char_speciale WHERE surname != ASCIISTR (surname)

----------------------------

SURNAME NAME

ara€ ssa
SE£ GRA


-------------------------------------------------------------------------------------------------------------


but i don't see just query, because i'll want to find also extended ascii, for example german "o" or french "e", ecc.
on my table use NLS_CHARACTERSET: AL32UTF8

i don't know that i have insert just query but i'm not sure.... do have better solution? thank much
This post has been answered by chris227 on Jul 12 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 9 2012
Added on Jul 11 2012
8 comments
2,375 views