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

ÇóÒ»¸öOracle²écountµÄÓï¾ä

ÓÐÈýÕűí
tableA ×Ö¶Î aid,aname
tableB ×Ö¶Î aid,bid
tableC ×Ö¶Î cid,cname,aid

ÎÒÒª²é³ö tableA µÄaid,aname ºÍtableBÖÐaidÏà¶ÔÓ¦µÄbid ºÍ tableCÖÐaidÏà¶ÔÓ¦µÄ×ÜÊý
ÎÒÔ­À´µÄ˼·ÊÇ
1¡¢select ta.aid,ta.aname,tb.bid from tableA ta,tableB b where ta.aid = tb.aid;
2¡¢±éÀúÉÏÃæ²é³öµÄList£¬Í¨¹ýaidÈ¥ select count(cid) from tableC where aid=.....

¿ÉÊÇÏÖÔÚµÚ1²½²éѯ£¬Êý¾ÝÁ¿ÓÖ4000¶àÌõ
Èç¹ûÔÚµÚ2²½È¥±éÀúµÄ»°£¬Òª²é4000¶à´Î

ºÄʱ1·Ö¶àÖÓ

ÓÐûÓÐÒ»ÌõSQLÓï¾äÄÜÂú×ãÎÒµÄÌõ¼þ£¿
¼±Ç󣡣¡
SQL code:
select a.aid,aname,bid,num from
(select a.aid,aname,bid from tableA a,tableB b where a.aid = b.aid) a,
(select aid,count(cid) num from tableC group by aid) b
where a.aid = b.aid;


select ta.aid,ta.aname,tb.bid,count(c.cid) over(partition by ta.aid)
from tableA ta,tableB b, tableC c
where ta.aid = tb.aid
and  ta.aid = c.aid(+);

ÒýÓÃ
select ta.aid,ta.aname,tb.bid,count(c.cid) over(partition by ta.aid)
from tableA ta,tableB b, tableC c
where ta.aid = tb.aid
and  ta.aid = c.aid(+);


UP

ÒýÓÃ
select ta.aid,ta.aname,tb.bid,count(c.cid) over(partition by ta.aid)
from tableA ta,tableB b, tableC c


Ïà¹ØÎÊ´ð£º

¼±ÎÊÒ»¸öoracle×Ö¶ÎÉèÖõÄÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷´óÀÏʦºÃ£¬Çë½ÌÒ»¸öÎÊÌ⣮
ÎÒÉèÖÃÁËÒ»¸öoracle×ֶΣ¬varchar(3000),È»ºó²åÈëÒ»ÌõÊý¾Ý³¤¶È²Å1000,¾Í±¨´íÁË£®È磺net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
Caused ......

oracleµ¼Èë»Ø¹ö - Oracle / ¿ª·¢

abnormal end of export file
IMP-00028: partial import of previous table rolled back: 3828 rows rolled back
  
ÓÐûÓÐÒ»ÖÖ·½·¨Èõ¼Èë¼ÌÐø½øÐжø²»Òì³£Ìø³ö»Ø¹ö£¿
ignore=y

Äã² ......

¹ØÓÚoracle 10gµÄsqlplus

ÏÖÔÚÎÒ±¾µØÃ»Óа²×°oracle, µ«plsqldevÐèÒªsqlplus.exeµÈ£¬ÇëÎÊoracle10gÔÚwindowsÐèÒª
ÄÄЩexeÎļþ£¬ÄÄλ´ó¸çÄÜ˳±ãÌṩһÏÂQQ£º190565390

×°oracleµÄʱºò¿ÉÒÔÑ¡ÔñÖ»×°¿Í»§¶ËµÄ

×îÆðÂëҪװoracle£¬ÄãÖ»Ðè×°¿ ......

oracleÊý¾Ý¿âµÄÃû×ÖÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒÔÚ´´½¨Êý¾Ý¿âµÄʱºòÓõÄÃû×ÖΪoracle10£¬µ«ÊÇ´´½¨ºÃºó£¬ÔÚĬÈϵÄĿ¼ÏÂÏÔʾµÄÃû³ÆÈ´ÊÇoracle10g£¬ÕâÊÇΪʲô£¿
Äã¿´µÄ 10gÊǰ²×°Ä¿Â¼°É 

SQL> select name from v$database;
NAME
---------
ORCL ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ