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
Ïà¹ØÎÊ´ð£º
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡ ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exist ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡ 1. Oracle sid ÕýÈ ......
×öÍædata guard ºó ÔÚPrimary·þÎñÆ÷ Ö´ÐÐ SQL>SELECT SEQUENCE#,APPLIED from V$ARCHIVED_LOG ORDER BY SEQUENCE#; SEQUENCE# APP ---------- --- 13 NO 13 YES ......
Ð»Ð»ÌÆÈËÀÏ´óµÄÖ¸µã£¬Ð»Ð»¸÷λ¸ßÊÖµÄÖ¸µã£¡ °²×°10g Enterprise¡£ÉÏÍøÏÂÁËMLDNµÄOracleÊÓÆµ£¬¸ú×ÅÊÓÆµÉϵÄÅäÖÃ×ߣ¬°²×°³É¹¦ÁË£¬µ«ÊÇûÍêÕûµØÅäÖᣠµã»÷½øÈ룺Database Configuration Assistant 1. ´´½¨Êý¾Ý¿â£»
......
ORACLEÅàѵ(OCA)ÈÏÖ¤½éÉÜ Oracle10g Certified Associate (OCA) Oracle ÈÏ֤רԱ¡£ ¿¼ÊԳɼ¨Í¨¹ýÄÜ»ñµÃOracle¹«Ë¾ÎªÄú°ä·¢µÄÈ«ÇòÈÏÖ¤µÄÓ¢ÎÄOCAÖ¤Êé¡£OCAÓÉOracle¹«Ë¾³öÌâ¡£ ¸ÃÖ¤Êé¿É×÷Ϊ¸÷ÆóÊÂÒµµ¥Î»Êý¾Ý¿ ......