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

oracle±Ê¼Ç

--oralceÖдӱíÖÐËæ»úÈ¡³önÌõ¼Ç¼
select * from  (select t.*,dbms_random.random num from fms_branch_info t order by num)    
where rownum <= 5;
--ȡǰʮÐÐ
SELECT t.* from fms_branch_info t
WHERE ROWNUM != 10
--WHERE ROWNUM between 1 and 10
ORDER BY branch_code;
--È¡µÚ¶þ¸öÊ®ÐÐ
select *
from (SELECT t.*,ROWNUM AS rn from fms_branch_info t)
where rn BETWEEN 11 AND 20;
--È¡×îºóÊ®ÐÐ
select st.*
from (SELECT t.*,ROWNUM AS rn from fms_branch_info t) st
where rn >
(
    SELECT MAX(st.rn -10) 
    from (SELECT t.*,ROWNUM AS rn from fms_branch_info t) st
);
    
--È¡ËùÓÐÆæÊý£¨Å¼Êý£©ÐÐ
select st.*
from (SELECT t.*,ROWNUM AS rn from fms_branch_info t) st
where mod(rn,2) != 0
ORDER BY branch_code;    
--OracleÖÐdecodeº¯ÊýÓ÷¨
º¬Òå½âÊÍ£º
    decode(Ìõ¼þ,Öµ1,·µ»ØÖµ1,Öµ2,·µ»ØÖµ2,...Öµn,·µ»ØÖµn,ȱʡֵ)
    decode(×ֶλò×ֶεÄÔËË㣬ֵ1£¬Öµ2£¬Öµ3£©
    SELECT DECODE (value, <if this value>, <return this value>) from table
    Õâ¸öº¯ÊýÔËÐеĽá¹ûÊÇ£¬µ±×ֶλò×ֶεÄÔËËãµÄÖµµÈÓÚÖµ1ʱ£¬¸Ãº¯Êý·µ»ØÖµ2£¬·ñÔò·µ»ØÖµ3
    µ±È»Öµ1£¬Öµ2£¬Öµ3Ò²¿ÉÒÔÊDZí´ïʽ£¬Õâ¸öº¯ÊýʹµÃijЩsqlÓï¾ä¼òµ¥ÁËÐí¶à
    ¸Ãº¯ÊýµÄº¬ÒåÈçÏ£º
IF Ìõ¼þ=Öµ1 THEN
¡¡¡¡¡¡¡¡RETURN(·µ»ØÖµ1)
ELSIF Ìõ¼þ=Öµ2 THEN
¡¡¡¡¡¡¡¡RETURN(·µ»ØÖµ2)
¡¡¡¡¡¡¡¡......
ELSIF Ìõ¼þ=Öµn THEN
¡¡¡¡¡¡¡¡RETURN(·µ»ØÖµn)
ELSE
¡¡¡¡¡¡¡¡RETURN(ȱʡֵ)
END IF
    ʹÓ÷½·¨£º
1¡¢±È½Ï´óС
select decode(sign(±äÁ¿1-±äÁ¿2),-1,±äÁ¿1,±äÁ¿2) from dual; --È¡½ÏСֵ
sign()º¯Êý¸ù¾Ýij¸öÖµÊÇ0¡¢ÕýÊý»¹ÊǸºÊý£¬·Ö±ð·µ»Ø0¡¢1¡¢-1
    ÀýÈ磺
            ±äÁ¿1=10£¬±äÁ¿2=20
            Ôòsign(±äÁ¿1-±äÁ¿2)·µ»Ø-1£¬decode½âÂë½á¹ûΪ“±äÁ¿1”£¬´ïµ½ÁËÈ¡½ÏСֵµÄÄ¿µÄ¡£
2¡¢´Ëº¯ÊýÓÃÔÚSQLÓï¾äÖÐ


Ïà¹ØÎĵµ£º

ΪOracleÊý¾Ý¿â´´½¨Óû§

Oracle°²×°Íêºó£¬ÆäÖÐÓÐÒ»¸öȱʡµÄÊý¾Ý¿â£¬³ýÁËÕâ¸öȱʡµÄÊý¾Ý¿âÍ⣬ÎÒÃÇ»¹¿ÉÒÔ´´½¨×Ô¼ºµÄÊý¾Ý¿â¡£
    ¶ÔÓÚ³õѧÕßÀ´Ëµ£¬ÎªÁ˱ÜÃâÂé·³£¬¿ÉÒÔÓÃ'Database Configuration Assistant'Ïòµ¼À´´´½¨Êý¾Ý¿â¡£
    ´´½¨ÍêÊý¾Ý¿âºó£¬²¢²»ÄÜÁ¢¼´ÔÚÊý¾Ý¿âÖн¨±í£¬±ØÐëÏÈ´´½¨¸ÃÊý¾Ý¿âµÄÓû§£¬ ......

OracleÖÐrownumµÄʹÓÃ

ÔÚʹÓÃOracleÖÐʹÓÃRownum£¬»áÓÐЩÎó½â£¬ÏÖÕûÀíÏÂÍøÓÑÃǵÄÎÄÕ£¬Ï£ÍûÄÜÓÐËù°ïÖú£¬ºÇºÇ
¶ÔÓÚ Oracle µÄ rownum ÎÊÌ⣬ºÜ¶à×ÊÁ϶¼Ëµ²»Ö§³Ö>,>=,=,between...and£¬Ö»ÄÜÓÃÒÔÉÏ·ûºÅ(<¡¢<=¡¢!=)£¬²¢·Ç˵ÓÃ>,>=,=,between..and ʱ»áÌáʾSQLÓï·¨´íÎ󣬶øÊǾ­³£ÊDz鲻³öÒ»Ìõ¼Ç¼À´£¬»¹»á³öÏÖËÆºõÊÇĪÃûÆäÃîµÄ½á¹û ......

oracle¿Í»§¶ËÁ¬½Ó ORA 06413 Á¬½Óδ´ò¿ª´íÎó

½ñÌìÔÚһ̨2003serverÉϰ²×° 9i¿Í»§¶Ë¡£
ÅäÖÃÁËtnsÖ®ºóÁ¬½Ó£¬±¨´í "ORA-06413 Á¬½Óδ´ò¿ª´íÎó".
°ÑÆäËü·þÎñÆ÷µÄtnsname.oraÖ±½Ó¿½±´¹ýÀ´Ò²²»ÐС£
ºóÀ´²éÁËÒ»ÏÂ×ÊÁÏ£¬ËµÓ¦ÓóÌÐò·¾¶Àï±ßÓÐÌØÊâ×Ö·û¡£
Õâ²Å»ÐÈ»´óÎò£¬Á½ÄêǰÕâ¸öÎÊÌâÒѾ­ÕÛÄ¥¹ýÎÒÒ»´ÎÁË£¬ÄÔ×Ó²»ºÃ£¬¾¹È»¸øÍüÁË¡£
Ô­Òò¾ÍÊÇ64λϵͳ»·¾³Ï°²×°oracle£¬oralc ......

Oracle¡¡ORA 12541:TNS:no listener´íÎó½â¾ö·½·¨

ǰÌì×°ºÃµÄ£Ï£ò£á£ã£ì£å£¬×òÌìͻȻ²»ºÃÓÃÁË£¬´ÓOracleµÄ´íÎóÌáʾÀ´¿´,ÊÇ˵TNS:no listener £¬¹À¼ÆÊÇijÖÖ·þÎñûÓÐÆô¶¯£¬´ò¿ªwindows¹ÜÀí¹¤¾ß->·þÎñ£¬Ò»¿´£¬ÓÐÒ»¸öOracleOraHome90TNSListenerÕâÑùµÄ·þÎñ£¬ºÍ´íÎóÐÅÏ¢ÌâÊÇÒ»Ö£¬»ù±¾¾Í¿ÉÒԿ϶¨ÊÇÕâ¸ö·þÎñËùÒý·¢µÄÎÊÌâ¡£ÔÙÒ»¿´£¬¸Ã·þÎñûÓÐÆô¶¯£¬ËìÊÖ¹¤Æô¶¯£¬Ë¢ÐºóÒ»¿´£¬¸Ã· ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ