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

ÔÚoracleÖйØÓÚÊ÷µÄsql

±ítask£¬×Ö¶Îid_£¬name_
id_µÄÊý¾ÝÈçÏÂÐÎʽ£º
1
1.1
1.1.1
1.1.1.2
1.2
1.2.1
...
10
10.1
10.1.1
10.2.1
10.2.1.1
10.2.1.1.1
10.2.1.1.2
.......
×¢£º“.”±êʶ¸¸×ӵĹØÏµ¡£
ÏÖÔÚͨ¹ýid_²éѯÊ÷½á¹¹µÄЧ¹û£¬²¢ÇÒÖªµÀ´Ë½ÚµãÊÇ·ñΪҶ×Ó½Úµãleaf¡£¡££¿
Óï¾äÈçÏ£º
select
id_ ,
name_ ,
(select count(id_) from  task where t.id_= substr(id_,0,INSTR((id_),'.',-1)-1) )  as  leaf,connect_by_isleaf from  task t 
  start with  t.id_ ='5' connect by prior
  t.id_= substr(t.id_,0,INSTR((t.id_),'.',-1)-1) order by t.id_


Ïà¹ØÎĵµ£º

Oracle ´´½¨³ÌÐò°ü


´Ó¸ÅÄʾÀý—Oracle´´½¨³ÌÐò°ü
Ò»¡¢³ÌÐò°üµÄÏà¹ØÖªÊ¶
1.¶¨ÒåÓë˵Ã÷
  a. Ïà¹Ø¶ÔÏóµÄ·â×°
  b. ³ÌÐò°üµÄ¸÷²¿·Ö
    - ³ÌÐò°ü¹æ¸ñ˵Ã÷
          ÉùÃ÷×Ó³ÌÐò
   - ³ÌÐò°üÖ÷Ìå
        ......

ORACLEÓÃLIMITʵÏÖÀàËÆ·ÖÒ³

Á·Ï°ÁËORACLEÀàËÆµÄ·ÖÒ³,Ä¿µÄ:ORACLEµÄLIMITʹÓÃ
declare
type name_arrary_type is varray(20) of varchar2(10);
name_arrary  name_arrary_type;
rowss int:=&ÊäÈëÒ³¼Ç¼Êý;
dpno int:=&ÊäÈ벿ÃźÅ;
v_count int:=0;
cursor  emp_cursor(dpno int) is select ename from emp where deptno=dpno; ......

ORACLEÈÕÆÚʱ¼äº¯Êý´óÈ«

TO_DATE¸ñʽ(ÒÔʱ¼ä:2007-11-02   13:45:25ΪÀý)
  
        Year:     
        yy two digits Á½Î»Äê               ......

ORACLE ÖÐROWNUMÓ÷¨×ܽá!


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

OracleɱµôËÀËø½ø³Ì

ÓÃOracle Sql Developer²Ù×÷±íµÄʱºò£¬²»ÖªÕ¦µÄ°Ñ±íËø×¡ÁË¡£
½á¹ûÄÇÕűíÒ»²åÊý¾Ý¾ÍËÀ£¬Á¬truncate¶¼²»ÐС£
´ÓÍøÉÏÆßÆ´°Ë´ÕÁ˸ö·½·¨£¬ÖÕÓڰѽø³ÌɱÁË£¬±íÒ²¾Í½âËøÁË¡£
Ê×ÏÈÒªÓÃdba¼¶±ðµÄÓû§²Ù×÷£¬ÒòΪҪ²ì¿´ºÜ¶àϵͳ±í¡£ÓÃÆÕͨÓû§²Ù×÷µÄ»°£¬»áÌáʾ±í»òÕßView²»´æÔÚ¡££¨ÎªÊ²Ã´²»ÌáʾȨÏÞ²»¹»£¿º¦ÎÒ×ÜÒÔΪÊǰ汾ÎÊÌ⣩
È ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ