Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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²é¿´Óû§Ëø±íÐÅÏ¢

select p.spid,
       a.serial#,
       c.object_name,
       b.session_id,
       b.oracle_username,
       b.os_user_name
  from v$proces ......

²é¿´¡¢ÐÞ¸Äoracle×Ö·û¼¯£¬²é¿´oracle°æ±¾

·½·¨Ò»£º
1)   ²é¿´·þÎñÆ÷¶Ë×Ö·û¼¯£º                                         &nbs ......

ORACLE ÖÐROWNUMÓ÷¨×ܽá!


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

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

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

groovy oracle date

There are lots of problems with Oracle DATE & TIMESTAMP and their
          counterpart Java classes since they do not directly compare. DATE fields
          in Oracle will give date & time where a ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ