oracle ¼¼ÊõQQȺ£º14840532£¬»¶Ó½»Á÷
»¶Ó½»Á÷
jf.......................
½Ó·Ö+½»Á÷
¼ÌÐø¶¥Æð¡£¡£¡£¡£¡£¡£¡£¡£¡£
ÉêÇëÉêÇ룬ºÇºÇ£¬½»Á÷
upÒ»¸ö
ÐÂÄê¿ìÀÖ~~~~
ÔªÏü½Ú¿ìÀÖ£¡
¶¥Ò»¸ö
¶¥ÆðÀ´¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£
×£´ó¼ÒÔªÏü½Ú¿ìÀÖ£¡£¡£¡
¶¥Æð£¬½Ó·Ö
¶¥Ò»Ï£¬¶¥Ò»Ï£¬¡£¡£¡£¡£¡£¡£
½Ó·Ö²ÅÊÇÍõµÀ,QQȺ,°ó¶¥,ѧÊõµÄ,»¹ÊÇÁÄÌìµÄ?
²»ÖªµÀÀïÃæµÄ¸ßÊÖϲ»¶°ï´ó¼Ò½â¾öÎÊÌâ²»¡¡
Ö§³Öһϣ¬·ÖÏí½»Á÷£¬¹²Í¬³É³¤£¡£¡
ºÃµÄ£¡~ ¶à½»Á÷²Å»áÓнø²½~ ÓÑÇéUp£¡~
¼ÓÒ»個¿´¿´~~~~~~~~~~~~
15µÄÔÂÁÁ16Ô²°¡ ¡£¡£°¡°¡¡£¡£°¡
Åã×ÅÅóÓÑÒ»Æð³ÔÌÀÔ²°¡¡£¡£¡£¡£°¡°¡°¡¡£¡£
ÉêÇë¡£JF »Ø¸´ÄÚÈÝÌ«¶ÌÁË£¡
лл·ÖÏí£¬¶à½»Á÷²Å»á½ø²½~ ¶¥
¶à¼Ó點ÈË進來°É~
¶à¼ÓµãÈ˽øÀ´£¬ÌÖÂÛ¸ü¼¤ÁÒ£¬¸üÓÐÀûÓÚÎÊÌâµÄ½â¾öÒÔ¼°Ã¿¸öÈ˵Ľø²½
¼ÌÐøUP!!!!!
¸ÃȺÓÐ˽¨¹ýORACLE RAC?
ÐÂÈË¿ÉÒÔ²»£¬ºÇºÇ£¬ºÜ²ËµÄÄÇÖÖ¡£
Ö§³Ö£¬·ÖÏí½»Á÷£¬¹²Í¬³É³¤£¡£¡!
ÉêÇë¼ÓÈ룡thunderbolt_0618!
½»Á÷.........
ÕýÔÚÉêÇë¼ÓÈ룬¶¼ÊÇCSDNµÄÐֵܰ¡¡¡
ÉêÇë¼ÓÈëÖУ¬µÈ´ýÑéÖ¤
up
»Ø¸´ÄÚÈÝÌ«¶ÌÁË£¡
½Ó·Ö¶ù½»Á÷Á½²»Îó~~~
ÖØÇì˹±ÌÊËÈí¼þÊÇOracle¹Ù·½ÊÚȨµÄÎ÷ÄϵØÇøÎ¨Ò»µÄWDPÅàѵ¼°¿¼ÊÔÖÐÐÄ¡£ÏëÒªOracle¿Î³Ì²¢ÇÒ¿¼OCPÖ¤ÊéµÄÅóÓÑ¿ÉÒÔÁ˽âһϡ£
Äú
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË
ÒýÓÃ
oracle ......
select sum£¨a.t)from ta a group by ta.a,ÕâÌõÓï¾ä½«±ítaÖеÄÊý¾Ý°´ÕÕa×ֶηÖ×é»ã×Üt×ֶΡ£
½á¹û±ÈÈ磺
3 30
4 50
ÎÒÏëµÃµ½Õâ¸ö½á¹û£º
1 0
2 0
3 30
4 50
5 0
Õâ¸ö½á¹û£¬ÇëÎÊsqlÓï¾äÔõôд£¿¶àл
nobody ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN
......