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 out the sql query for special characters.

kn_sivaramanJun 13 2012 — edited Jun 13 2012
Hi,

I have the emp table with column name first_name.In that table i have lot records with first_name inlcudes the below mentioned special characters.

¡ , ¿, ,Ä,Å,ä,ª,À,Á,Ã,à,á,ã,å,Æ,æ,Ç,ç,È,É,Ê,Ë,è,é,ê,ë,Ì,Í,Î, Ï,ì,í,î,ï, Ñ,ñ, ô, º, Ò, Ó, Ô, Õ, Ö, Ø, ò, ó, õ, ö, ø, ß, Û, Ù, Ú, Ü,ù, ú, û, ü, ÿ,

I am looking for the records with includes the above mentioned special characters in the first_name column.

Can u please give the sql query to find out the records.


Thanks&Regards
N.Sivaraman
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 11 2012
Added on Jun 13 2012
3 comments
5,924 views