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·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ ÒýÓà ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿ÔÀ´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......
java.sql.SQLException: Io Òì³£: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=186646784)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4)))) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBErro ......
×öÍædata guard ºó ÔÚPrimary·þÎñÆ÷ Ö´ÐÐ SQL>SELECT SEQUENCE#,APPLIED from V$ARCHIVED_LOG ORDER BY SEQUENCE#; SEQUENCE# APP ---------- --- 13 NO 13 YES ......