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
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£ ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£ ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£ ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£ ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î date(Ö÷) outid(Ö÷) inid(Ö÷) num amt 2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡ oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË ÒýÓà oracle ......
Ö÷ÒªÏëʵÏÖ£ºÔÚÿÌìµÄ0µã֮ǰ×Ô¶¯½«Êý¾Ý²åÈëÊý¾Ý¿â£¬Ï£Íû´ó¼ÒÖ¸µã£¡ ×Ô¶¯²åÈë?Êý¾ÝÔ´ÄÄÀïÀ´µÄ,²åÈ뵽ʲôµØ·½ ´¥·¢Æ÷? Ó¦¸ÃÓÃJOB Êý¾ÝÔ´ÔÝʱÏëµÄÊǹ̶¨Êý¾Ý£¬²åÈëµ½Ò»Õűí ÄǾÍÊÇÓÃJOB¶¨Ê±Ö´ÐÐ,´ÓÎļþµ¼ÈëÊ ......