ADOConnection¡¢dbexpora Á¬½Óoracle ¾ÍÊÇÁ¬²»ÉÏ£¬ora£12546´íÎó¡£
ÓÃodbcÄÜÁ¬ÉÏ£¬pl/sqlÒ²ÄܵǼ¡£
ÔõôŪ°¡£¿Ð»Ð»£¡
Èç¹ûplsqlÄÜÁ¬ÉÏ,¿´Ñù×ÓtnsÅäÖÃÓ¦µ±Ã»ÎÊÌâ,¹À¼Æ¾ÍÊÇÄãµÄÁ¬½Ó×Ö´®ÓÐÎÊÌâ,
adoconnectionµÄÁ¬½ÓÊÇÔõôдµÄ£¬Ò»°ãÑ¡ÔñoracleµÄÄǸöÇý¶¯£¬±ðÓÃ΢ÈíµÄ¡£
×îºÃÓÃodac£¬Õâ¸öÁ¬½Óoracle×î·½±ã¡£
......
OracleÊý¾Ý¿âÓÃPLSQLÈçºÎʹÓÃbetween and ²éѯ ÎҵıíÖеÄʱ¼ä¸ñʽÊÇ 2009-11-2 8:47:14 ÕâÑùµÄ£¬Çë½Ì£¬ÈçºÎʹÓÃbetween and Õâ¸öʱ¼ä¶Î £¬È磺select * from table where dj_date between ¡®2009-11-1 8:47:14¡¯ and '2009-12-1 8:47:14' ¶Ô·ñ£¬ÇëÖ¸½Ì£¬Âé·³¸ø³öÕýÈ ......
Ŀǰ´òË㹺ÂòÒ»Ì×Õý°æoracleÊý¾Ý¿â
ÏÖÔÚ·ÖΪ°´cpu¸öÊýÒÔ¼°Óû§ÊýÀ´¼Æ·Ñ
Èç¹û°´Óû§ÊýÀ´¼Æ·Ñ£¬ÄÇôÕâÀïµÄÓû§ÊýÖ¸Ê²Ã´ÄØ£¿¡¾Èç¹ûÊÇ30¸öÓû§¡¿
Óû§ÊýÁ¿30ÊÇ·ñÖ¸Á¬½Óµ½Êý¾Ý¿âµÄ¿Í»§¶ËÖ»ÓÐ30̨PC£¬»¹ÊÇÖ¸Êý¾Ý¿â¿ÉÒÔ°²×°µ½30̨PCÖУ¿
Çë´ó¼Ò°ïæ½â´ðһϣ¡
»¹ÓÐÒ»¸öÎÊÌ⣬ע²áµ½Êý¾Ý¿âÖеÄÓû§ÊýÕâ¸öÔõôÀí½ ......
ÈçÌ⣺ÈçºÎ²é¿´oracle¿ªÏú£¬»òÊÇsqlµÄÖ´ÐÐЧÂÊ¡£
¡¾1¡¿Ôõô²é¿´Êý¾Ý¿âµ±Ç°ÔËÐжÔ×ÊÔ´µÄÕ¼ÓÃÇé¿ö£¬¾ßÌåÊÇÄǸöÈÎÎñÔÚÕ¼Óá£
¡¾2¡¿Ôõô²é¿´¾ßÌåsqlÓï¾äµÄÖ´ÐÐЧÂʺͶÔ×ÊÔ´µÄÕ¼Óã¬ÈçºÎµ¥¶À·ÖÎösqlµÄÓÅÂÔ¡£
Ï£Íû´ó¼Ò²ÎÓë½»Á÷£¡
¡¾1¡¿TOPÃüÁî
ÎÒÒ²²»ÊǺÜÇå³þ
ÒýÓÃ
ÈçÌ⣺ÈçºÎ²é¿´oracle¿ªÏú£¬»òÊÇsqlµÄÖ´ÐÐЧ ......
ID Ãû×Ö ÏúÊÛ¶î »·±È
1 aa 20.2 0
1 aa 15.2 (15.2-20.2)/20.2
1 aa 23.0 ......
»úÆ÷Ò»£º°üº¬ºÜ¶àÊý¾Ý¿â¶ÔÏó
Ä¿±ê£º½«ÕâЩÊý¾Ý¿â¶ÔÏóÇ¨ÒÆ³öÒ»²¿·Öµ½Ð»ú2
ÎÊÌ⣺ӦÓõÄÊý¾ÝÁ¬½Ó³ØÖ¸ÏòлúÒ»£¬µ«ÊÇ»¹ÐèÒª·ÃÎÊлú2ÖеÄÓ¦Óá£ÔÚ²»¸Ä±ä´úÂëµÄÇé¿öÏÂÈçºÎ½â¾ö
Àý:лú2Óиö¶ÔÏó½Ðtest
1¡£ÒòΪÔÀ´ËùÓжÔÏó¶¼ÔÚһ̨»úÆ÷ÉÏ£¬´úÂëÖвéѯÓï¾äÊÇÕâÑùµÄselect * from test.table;
2¡£²ð·ÖÍêÖ®ºóÈç¹ûÊ ......