ÇóÒ»Ìõoracle¶à±í²éѯµÄsql£¬Çó¸ßÊÖÃDz»ÁߴͽÌ~
table1:
uID uName
1 СÀî
2 СÕÅ
table2:
pID uID type
1 1 H1
2 2 H2
table3:
uID teamID
1 T1
1 T2
1 T4
2 T1
2 T3
2 T4
2 T5
table4:
teamID teamName
T1 Ò½ÁÆ
T2 ¾È»¤
T3 ¼±¾È
T4 Ò½Ò©
T5 ÆäËû
ÏÖÔÚÏëÒªÒ»ÌõSQL²éѯ³öÈçϵĽá¹û
uID uName team type
1 СÀî Ò½ÁÆ£¬¾È»¤£¬Ò½Ò© H1
1 СÕÇ Ò½ÁÆ£¬¼±¾È£¬Ò½Ò©£¬ÆäËû H2
Çë¸ßÊÖÃDz»ÁߴͽÌ~~¸Ð¼¤²»¾¡
select a.uid,a.uname,
wm_concat(d.teamname),
b.type
from table1 a,table2 b,table3 c,table4 d
where a.uid=b.uid
and a.uid=c.uid
and c.teamid=d.teamid
group by a.uid,a.uname,b.type
²»ºÃÒâ˼£¬ÎÒÍü¼Ç˵ÁË£¬ÏµÍ³ÓõÄÊý¾Ý¿âÊÇ9iµÄ£¬Ã»ÓÐwm_concatÕâ¸öº¯Êý£¬»¹ÓÐûÓбðµÄ°ì·¨£¿
ÓÃsys_connect_by_path
http://topic.csdn.net/u/20091010/14/FC773
Ïà¹ØÎÊ´ð£º
sql¿ÉÒÔÓÐÁ½¸öÒÔÉϵĴ¥·¢Æ÷Â𣿣¿ÎÒÖ¸µÄÊÇfor´¥·¢Æ÷£¬ÄÇÆäËûµÄÄØ£¿£¿
ʲôÒâ˼£¿
¿ÉÒÔµÄ
10¸ö¶¼Ã»ÎÊÌâ
¿ÉÊÇÎÒдÁËÁ½¸öfor insert ´¥·¢Æ÷£¬Ôì³É½ø³Ì×èÈûÁËÄØ£¿Ôõô°ìÄØ£¿Çë¸ßÈËÖ¸µã
......
¸÷λ´óÏÀ¾ÈÃü°¡ £¡£¡
¸Õ×°ÁËSQL2000 sp3
ÏëÓÃJSPÁ¬½ÓÊý¾Ý¿âµ«ÊdzöÏÖÎÊÌâÁË
ÎÒÓõÄÊÇJDK6.0+tomcat5.0+SQL2000 SP3+JDBC sp3
ËüÏÔʾµÄÊÇ
javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver fo ......
ÏÖÔÚÓÐÒ»ORACLEÖеÄSQLÓï¾ä£¬ÐèÒªÒÆÖ²µ½DB2ÖУ¬ÇëÎʸÃSQL¸ÄÈçºÎд
ORACLEÖУº
select floor(months_between(date1,date2)) from A
date1,date2·Ö±ðΪ±íÖеÄÁ½¸ö×ֶΠ£¬¶¼ÎªÈÕÆÚÐÍ
DB2ÖÐÈçºÎʹÓÃÐ ......
°²×°ÁËOracle 10g£¬Ä¬ÈÏ°²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿
1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
abnormal end of export file
IMP-00028: partial import of previous table rolled back: 3828 rows rolled back
ÓÐûÓÐÒ»ÖÖ·½·¨Èõ¼Èë¼ÌÐø½øÐжø²»Òì³£Ìø³ö»Ø¹ö£¿
ignore=y
Äã² ......