ORACLE ×ÜºÍ SUM ÎÊÌâ
±ÈÈ磺
ÓÐÕűíΪËùÓдúÀíÉÌÿÈÕ·¢Õ¹µÄ²»Í¬Æ·ÅƵÄÊýÁ¿£¨2008Äê¼ä£©
´úÀíÉÌID Æ·ÅÆ ÈÕÆÚ ÈÕ·¢Õ¹Á¿
1111 a 20080101 1
2222 a 20080101 2
1111 b 20080102 3
1111 a 20080102 2
2222 a 20080201 1
2222 a 20080202 1
...
...
ÈçºÎͳ¼Æ³öÏà¶ÔÓÚijÌìµÄ²»Í¬Æ·ÅƵı¾ÔÂ×Ü·¢Õ¹Á¿£¬È»ºó×îºóÒªÔö¼Óµ½ÉÏÃæµÄбíÖС£
±ÈÈçͳ¼Æ³ÉÕâÑùµÄ£º
´úÀíÉÌID Æ·ÅÆ ÈÕÆÚ ÈÕ·¢Õ¹Á¿ ±¾Ô·¢Õ¹Á¿
1111 a 20080101 1 1
2222 a 20080101 2 2
1111 b 20080102 3 3
1111 a 20080102 2 3
....
....
2222 a 20080201 1 1
2222 a 20080202
Ïà¹ØÎÊ´ð£º
°²×°11gµÄ06,´ò²¹¶¡Éýµ½07£¬´ÓODBCÀïÃæ¿´£¬ÓÐ
Oracle in OraOdac11g_home1 11.01.00.07
´Ó×¢²á±í¿´HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ÏÂÃæµÄDriverºÍSetup¶¼ÊÇÎҵݲװ·¾¶
"D:\\app\\Ad ......
±í¼Ç¼
======================================
name date score
Fei Zhang 1 100
Fei Zhang  ......
´ó¼ÒºÃ£¬ÔÚ¿ª·¢µÄʱºò£¬Óöµ½ÕâÑùµÄÎÊÌ⣺
δÄܼÓÔØÎļþ»ò³ÌÐò¼¯¡°Oracle.DataAccess, Version=10.1.0.200, Culture=neutral, PublicKeyToken=89b483f429c47342¡±»òËüµÄijһ¸öÒÀÀµÏϵͳÕÒ²»µ½Ö¸¶¨µÄÎļþ¡£ ......
ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
¸½Í¼Æ¬ ......
Óö¼ûÁËÒ»¸öÕâÖÖÇé¿ö A ÔÚÄÚÍø B ÓÐÄÚÍøºÍÍâÍøµÄÍø¿¨ C ΪÍâÍø
Oracle Server ×°ÔÚAÀï ÏÖÔÚÖ»Äܱ»B·ÃÎÊ
ÏëÇëÎʸ÷·¸ßÊÖ Ä ......