Oracle 10 ÓÃÕýÔò±í´ïʽ²éÕÒÈ«½Ç×Ö·û

ÇëÎʸ÷룬ÔÚOracle 10G R2ÖУ¬ÔõôʹÓÃÕý¹æ±í´ïʽÀ´²é¿´×Ö¶ÎÖÐÊDz»ÊÇ°üº¬ÖÐÎÄÈ«½Ç×Ö·û°¡£¿ÀýÈç¡°£¬¡££¿¡¶¡·¡±Ö®ÀàµÄ

---

[^\x00-\xff]±íʾȫ½Ç¡£¡£¡£

---

û×ö¹ý£¬¹Ø×¢£¬Ñ§Ï°¡£¡£¡£

---

SQL code:

select * from aaa
where regexp_like(name,'[^\x00-\xff]')


ÓÃÕâ¸ö¹«Ê½»á²é³öËùÓнá¹û£¬È«½ÇµÄ°ë½ÇµÄ¶¼³öÀ´ÁË£¬Ó¦¸ÃÔõôÐ޸İ¡£¿

---

Èç¹ûÊÇÖÐÎÄ×Ö·û¼¯£¬Òª²éѯÊÇ·ñ°üº¬È«½Ç¿ÉÓÃ
select * from aaa where length(name) <>lengthb(name);

---

ÒýÓÃ

Èç¹ûÊÇÖÐÎÄ×Ö·û¼¯£¬Òª²éѯÊÇ·ñ°üº¬È«½Ç¿ÉÓÃ
select * from aaa where length(name) <>lengthb(name);

×Ö¶ÎÖаüº¬ÖÐÎĵģ¬Ö»ÒªÈ«ÊÇÖÐÎÄÈ«½ÇµÄlengthb(name)µÄÖµÊÇlength(name)µÄ2±¶°¡¡£ÏÖÔÚÊÇÏë²éѯÖУ¬Õâ¸öЩÖÐÎÄÊDz»ÊÇ°üº¬È«½ÇµÄ×Ö·û£¬ÏµÍ³ÖгýÁ˺º×ÖÍâÏëʹÓðë½ÇµÄ×Ö·û

---

SQL code:

---µÈÓÚ0´ú±íûÓÐ,´óÓÚ0´ú±í°üº¬ÖÐÎÄÈ«½Ç×Ö·û
SQL> select regexp_instr('safafsdf?sdfasdf','[^a-z|A-Z|0-9]') from dual;

REGEXP_INSTR('SAFAFSDF?SDFASDF
------------------------------
9

SQL> select regexp_instr('safafsdfsdfasdf','[^a-z|A-Z|0-9]') from dual;

REGEXP_INSTR('SAFAFSDFSDFASDF'
------------------------------
0

SQL> select regexp_instr('safa¡¶fsdfsdfasdf','[^a-z|A-Z|0-9]') from