oracle ÖÐÆ¥ÅäÊý×Ö - Oracle / »ù´¡ºÍ¹ÜÀí

ÈçºÎÔÚoracleÖÐÆ¥ÅäÊý×Ö£¬°æ±¾ÊÇoracle9 

SQL code:

select * from ldjorderhist lj where length(lj.orderid)<=6 and substr(lj.orderid,1,1) like '^[1-9]'



ÕâÑù²é²»³öÀ´

---

9i°æ±¾²»Ö§³ÖÕýÔò
Èç¹ûÖ»ÊÇÒªorderidµÚһλΪ·ÇÊý×Ö
¸Ä³É
select * from ldjorderhist lj where length(lj.orderid)<=6 and (lj.orderid<'0' or lj.orderid>':');

---

ÒýÓÃ

9i°æ±¾²»Ö§³ÖÕýÔò
Èç¹ûÖ»ÊÇÒªorderidµÚһλΪ·ÇÊý×Ö
¸Ä³É
select * from ldjorderhist lj where length(lj.orderid)<=6 and (lj.orderid<'0' or lj.orderid>':');

ͬÒâ´Ë·½·¨

---

ÒýÓÃ

9i°æ±¾²»Ö§³ÖÕýÔò
Èç¹ûÖ»ÊÇÒªorderidµÚһλΪ·ÇÊý×Ö
¸Ä³É
select * from ldjorderhist lj where length(lj.orderid)<=6 and (lj.orderid<'0' or lj.orderid>':');

²é³öÀ´ÁË tks