Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 10g webµÇ½EMµÄÎÊÌ⣿ - Oracle / »ù´¡ºÍ¹ÜÀí

°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿

1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......

OracleÀëÏß·ÃÎÊ---ÇóÖú - Oracle / »ù´¡ºÍ¹ÜÀí

´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄԭʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
    ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......

oracleÓëaix - Oracle / ¸ß¼¶¼¼Êõ

ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼­¾íºÅlv04 
#lslv -l lv04 ......

oracle 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......

oracle³õѧÕßÄãÇë½Ì - Oracle / »ù´¡ºÍ¹ÜÀí

--½¨Á¢Ò»¸ö°üÒÔ¶¨ÒåÒ»¸öÓαê
create or replace package PK_test 
as 
type cur_test is ref cursor;
end PK_test;
--½¨Á¢Ò»¸ö¹ý³Ì,ͨ¹ýÊäÈëJOBID£¬·µ»ØÒ»¸ö±í¼Ç¼£¨Óα꣩!
create or replace ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ