Oracle 8.1.6 ÈçºÎ²éÕÒ×Ö·û´®ÖÐÊÇ·ñº¬ÓÐСд×Öĸ£¿

ÓÐûÓа취ͨ¹ýÒ»ÌõSQL²éÕÒ³ö°üº¬Ð¡Ð´×ÖĸµÄ¼Ç¼¡£¡£ ÇëÖ¸½Ì£¡~

---

select * from table1 where name like ¡®%[a-z]%¡¯;

---

ÒýÓÃ

816


SELECT * from table_name
WHERE colname LIKE '%chr(97)%' OR colname LIKE '%chr(98)%' OR ... OR colname LIKE '%chr(122)%';

²»ÊÇ°É£¿..ÓÐûÓÐÆäËûµÄ·½·¨£¿..

---

select  * from tablename where fieldname like '%[a-z]%'

---

ÒýÓÃ

select  * from tablename where fieldname like '%[a-z]%'

Õâ¸ö·½·¨²éѯ²»µ½¼Ç¼..

---

ÒýÓÃ

select * from ±íÃû WHERE ±í×ֶΠ <>upper(±í×Ö¶Î)

Õâ¸ö¿ÉÒÔ£¬Âé·³½âÊÍÏÂʲôԭÀí£¿..

---

upperÈ¡´óд×Öĸ£¬Óë×ÔÉí×ö±È¶Ô£¬²»Ò»ÖµÄɸѡ³öÀ´~ ÎÒÀí½âµÄ¶Ôô£¿..

---

ѧϰ£¡~

---

ÒýÓÃ

upperÈ¡´óд×Öĸ£¬Óë×ÔÉí×ö±È¶Ô£¬²»Ò»ÖµÄɸѡ³öÀ´~ ÎÒÀí½âµÄ¶Ôô£¿..

ÊǵÄ