Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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

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

SQL code:

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



ÕâÑù²é²»³öÀ´
orderid ÊǶ©µ¥±àºÅ £¬Òª²é³öÒÔÊý×Ö¿ªÍ·²¢ÇÒ³¤¶ÈСÓÚ6λµÄ ¶©µ¥ÐÅÏ¢ 
Èç orderid 56789,75895µÈµÈÖ®ÀàµÄ  

±íÖÐorderid ÓÐÈçϸñʽµÄ£º N54145 £¬20100512174314,57894£¬¡£¡£¡£¡£¡£¡£¡£

oracle9²»ÄÜʹÓÃÕýÔò±í´ïʽ£¬¿ÉÒÔʹÓÃtranslate+trimÁ½´Î£¬Êý×ÖÑ¡³öÀ´


select * from ldjorderhist lj where length(lj.orderid)<=6 and substr(lj.orderid,1,1) between 0 and 9


 ÆÚ´ý¸üºÃµÄ°ì·¨

Èç¹ûÖ»ÊÇÊý×Ö¿ªÍ·µÄÄǾͺܺðìÁË,substrµÃÁË£¬Èç¹ûÈ«ÊÇÊý×ֵIJ»ÄÜÓÃÕýÔò¾ÍÓÃtranslate

ÒýÓÃ
select * from ldjorderhist lj where length(lj.orderid)<=6 and substr(lj.orderid,1,1) between 0 and 9


ÆÚ´ý¸üºÃµÄ°ì·¨


²»ÐÐ £¬orderID ÓÐÀàËÆÓÚ N20145 ×Öĸ¿ªÍ·µÄ¶©µ¥ºÅ£¬ÕâÑù²éѯ»á±¨´í£ºÎÞЧµÄÊý×Ö

select * from ldjorderhist lj where length(lj.orderid)<=6 and substr(lj.orderid,1,1) IN('0','1','2') ÕâÑù¡£¡£?


select * from ldjorderhist lj where length(lj.orderid)<=6 and substr(lj.orderid,1,1) between '0' and '9'

ÕâÑùÒ²¿ÉÒÔ¡£¡£

SQL code



Code highlighting produced by Actipro CodeHighlighter (fre


Ïà¹ØÎÊ´ð£º

oracle²¢·¢´¦ÀíSOS - Oracle / ¿ª·¢

ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾ­ºÜ³ÉÊìÁË

ÒýÓÃ
oracle ......

JavaÖ®¸¸À뿪Oracle£¬±¯Í´°¡£¡£¡ - Java / ·Ç¼¼ÊõÇø

¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬
ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡
OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Âð£¿
SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......

¹ØÓÚOracle´¥·¢Æ÷µÄÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

Ö÷ÒªÏëʵÏÖ£ºÔÚÿÌìµÄ0µã֮ǰ×Ô¶¯½«Êý¾Ý²åÈëÊý¾Ý¿â£¬Ï£Íû´ó¼ÒÖ¸µã£¡
×Ô¶¯²åÈë?Êý¾ÝÔ´ÄÄÀïÀ´µÄ,²åÈ뵽ʲôµØ·½
´¥·¢Æ÷?
Ó¦¸ÃÓÃJOB

Êý¾ÝÔ´ÔÝʱÏëµÄÊǹ̶¨Êý¾Ý£¬²åÈëµ½Ò»Õűí

ÄǾÍÊÇÓÃJOB¶¨Ê±Ö´ÐÐ,´ÓÎļþµ¼ÈëÊ ......

OracleÈÏÖ¤ - Oracle / ÈÏÖ¤Ó뿼ÊÔ

ORACLEÅàѵ(OCA)ÈÏÖ¤½éÉÜ 
Oracle10g Certified Associate (OCA) Oracle ÈÏ֤רԱ¡£
¿¼ÊԳɼ¨Í¨¹ýÄÜ»ñµÃOracle¹«Ë¾ÎªÄú°ä·¢µÄÈ«ÇòÈÏÖ¤µÄÓ¢ÎÄOCAÖ¤Êé¡£OCAÓÉOracle¹«Ë¾³öÌâ¡£
¸ÃÖ¤Êé¿É×÷Ϊ¸÷ÆóÊÂÒµµ¥Î»Êý¾Ý¿ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ