oracleÖÐʵÏֵݹé²éѯµÄSQL£¨connect by prior£©
Ç°¶Îʱ¼ä×öÁËÒ»¸öÐéÄâ×éÖ¯µÄ´´½¨¡£Õâ¸öÐéÄâ×éÖ¯µÄ´´½¨ÊÇ´ÓÏÖÓеÄ×éÖ¯ÖжÁÈ¡Êý¾ÝÈ»ºó½øÐзÖÎö±£´æµ½ÐéÄâ×éÖ¯±íÖС£±£´æÖ®ºóдÈÕÖ¾·½±ãͬ²½µ½ÆäËüϵͳÖС£¹«Ë¾Ê¹ÓõÄÖ÷Òª¼¼ÊõÊÇSSH¡£ÓÉÓÚÊÇÐÂÈËûÓÐʲô¾Ñ飬¼Ó֮ʱ¼ä±È½Ï½ôÆÈ£¬×îºóʹÓÃÒ»°ãµÄÂ߼˼Ïëͨ¹ýµÝ¹éÔÚhibernateÏÂ˳Àû´´½¨ÁË¡£¿ÉÊÇ´ÓÏÖÓеÄ×éÖ¯ÖжÁÈ¡10¶àÍòÌõµÄ¼Ç¼£¬È»ºóÖðÌõ·ÖÎö£¬±£´æ£¬ÔÚдÈÕÖ¾¼Ç¼£¬ÔÚΪÿ¸öÓ¦ÓÃдÏ·¢¶ÓÁнá¹ûÐÔÄܷdz£µÍ¡£ÎÒÃǵÄϵͳÖеÄÊý¾ÝҪϷ¢µ½300¶à¸öÓ¦ÓÃϵͳ£¬Ò²¾ÍÊÇ˵¶ÁÈ¡10¶àÍòÌõ¼Ç¼¾ÍÒª·ÖÎöÊ®¶àÍò´Î£¬È»ºóÖðÌõд3000¶àÍòÌõ¼Ç¼£¬Ð§ÂÊ¿ÉÏë¶øÖªÁË¡£ºóÀ´Ê¹ÓöàÏß³ÌÀ´ÊµÐÐͬ²½£¬¿ÉÊDZ£´æµÄ¹ý³ÌÒÀÈ»ÓÃÊ®¼¸·ÖÖÓ¡£Õâ¸ö¹ý³ÌÊDz»ÄÜÈÃÈ˽ÓÊܵġ£
Ö®ºóÓÅ»¯ÐÔÄܵŤ×÷תµ½ÁËÎÒµ¼Ê¦µÄÊÖÖС£ÎÒµ¼Ê¦µÄְλÊÇϵͳ¼Ü¹¹Ê¦£¬Äê½üËÄÊ®£¬¿ÉÒÔ˵ÊÇjavaÔªÀϼ¶ÈËÎïÁË¡£Á½ÌìÖ®ºó¹ûÈ»´«³öÕñ·ÜÈËÐĵÄÏûÏ¢¡£±£´æ¹¤×÷´ÓÔÀ´µÄºÄʱ10¶à·ÖÖÓ±ä³ÉÁË°ë·ÖÖÓ¡£ÕæÊÇ´óϲ°¡£¡
½ñÔçÀ´Éϰ࣬µÚÒ»¼þʾÍÊÇ¿´¿´ÊÇʲôʵÏֵġ£µÚÒ»¾ÍÊDz»Ê¹Óù«Ë¾·â×°ºÃµÄÊý¾Ý¿âÁ¬½Ó£¬²»ÊÊÓÃHQL¶øÊÇsqlÅúÁ¿±£´æ¡£Õâ¸öµ±È»ÄÜÌá¸ßºÜ´óµÄÐÔÄÜÁË¡£Ò²Åå·þµ¼Ê¦Ö®»¨ÁËÁ½ÌìµÄʱ¼ä°ÑÎÒÊ®ÌìµÄд³öÀ´µÄÂß¼ÖØÐÂÕûÀíÁËÒ»±é£¬ÕæÊDz»¼òµ¥°¡£¡×îºó¿´µ½Ò»ÌõSQLÈçÏ£ºselect * from um_org_organization_info start with ouguid=? connect by prior ouguid=parentouguid¡£¿ªÊ¼¾õµÃºÜÒÉ»ó£¬ÒÔÎÒ֮ǰËùѧϰµÄSQ֪ʶ£¬²»Ôø¿´¼û¹ýstart with ...connect by prior,ÒÉ»óÖ®¼ÊÉÏÍø¿´¿´¡£µÃÖª“Start with...Connect By prior ×Ó¾äµÝ¹é²éѯһ°ãÓÃÓÚÒ»¸ö±íά»¤Ê÷ÐνṹµÄÓ¦ÓÃ" ¡£ÖÕÓÚ´óÎòÁË¡£¸ßÊÖ¾ÍÊDz»Ò»Ñù£¬¾Ñé¶à¼ûʶ¹ã°¡¡£½ñÌìÓÖѧÁËÐÂ֪ʶÁË¡£ºÙºÙ£¡
Ïà¹ØÎĵµ£º
create table emp2_log(
uname varchar2(20),
action varchar(10),
atime date
);
create or replace trigger trig
after insert or delete or update on emp2 for each row //°óÔÚÒ»ÕűíÉÏ,before after ¶¼¿É
ÒÔ,beforeÊÇ ²åÊý¾Ý֮ǰ£¬afterÊÇÖ®ºó
begin
&nb ......
½â¾ö·½·¨...
¹ØÓÚSQL°²×°±»¹ÒÆðµÄÐÞ¸´´ó¼Ò¿ÉÄܶ¼Óöµ½¹ýµ±SQL±»É¾³ýºóÐèÒªÖØа²×°Ê±£¬½øÈë°²×°½çÃæ¾Í»á³öÏÖSQL´íÎóÌáʾ£º
´ÓÇ°µÄ°²×°³ÌÐò²Ù×÷ʹ°²×°³ÌÐò²Ù×÷¹ÒÆð£¬ÐèÒªÖØÐÂÆô¶¯¼ÆËã»ú
È»¶øÕâЩ¶¼Êǰ׷Ѿ¢£¬²»¹ÜÄãÖØÐÂÆô¶¯¶àÉÙ´ÎÒ²¶¼ÎÞ¼ÃÓÚÊ£¬ÏÂÃæÎҾͽ²½²ÔõÑùÄܹ»½â³ý°²×°»òÉý¼¶Ê±Îļþ±»¹ÒÆðµÄ²Ù×÷¡£
µã»÷ ¿ ......
ORACLE sql µÄ´¦Àí¹ý³Ì´óÖÂÈçÏ£º
1.ÔËÓÃHASHËã·¨£¬µÃµ½Ò»¸öHASHÖµ£¬Õâ¸öÖµ¿ÉÒÔͨ¹ýV$SQLAREA.HASH_VALUE ²é¿´
2.µ½shared pool ÖÐµÄ library cache ÖвéÕÒÊÇ·ñÓÐÏàͬµÄHASHÖµ£¬Èç¹û´æÔÚ£¬ÔòÎÞÐèÓ²½âÎö£¬½øÐÐÈí½âÎö
3.Èç¹ûshared pool²»´æÔÚ´ËHASHÖµ£¬Ôò½øÐÐÓï·¨¼ì²é£¬²é¿´ÊÇ·ñÓÐÓï·¨´íÎó
&nbs ......
½«b±íÖÐcallerÁеÄÖµ²åÈëa±íÖÐcallÁÐÖС£
create table a
(
fid int,
call varchar(20),
age int
)
create table b
(
fid int,
caller varchar(20),
parentId int
)
select * from a
select * from b
insert into a values(1,null,19)
insert into a values(2,n ......