Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ : Oracle

ADOConnection Á¬½Óoracle Çë½Ì

ADOConnection¡¢dbexpora Á¬½Óoracle ¾ÍÊÇÁ¬²»ÉÏ£¬ora£­12546´íÎó¡£
ÓÃodbcÄÜÁ¬ÉÏ£¬pl/sqlÒ²ÄܵǼ¡£
ÔõôŪ°¡£¿Ð»Ð»£¡
Èç¹ûplsqlÄÜÁ¬ÉÏ,¿´Ñù×ÓtnsÅäÖÃÓ¦µ±Ã»ÎÊÌâ,¹À¼Æ¾ÍÊÇÄãµÄÁ¬½Ó×Ö´®ÓÐÎÊÌâ,

adoconnectionµÄÁ¬½ÓÊÇÔõôдµÄ£¬Ò»°ãÑ¡ÔñoracleµÄÄǸöÇý¶¯£¬±ðÓÃ΢ÈíµÄ¡£
×îºÃÓÃodac£¬Õâ¸öÁ¬½Óoracle×î·½±ã¡£
......

OracleÊý¾Ý¿âÓÃPLSQLÈçºÎʹÓÃbetween and ²éѯ

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Êý¾Ý¿âÏÞ¶¨µÄÓû§ÊýÖ¸Ê²Ã´ÄØ£¿

Ŀǰ´òË㹺ÂòÒ»Ì×Õý°æoracleÊý¾Ý¿â
ÏÖÔÚ·ÖΪ°´cpu¸öÊýÒÔ¼°Óû§ÊýÀ´¼Æ·Ñ
Èç¹û°´Óû§ÊýÀ´¼Æ·Ñ£¬ÄÇôÕâÀïµÄÓû§ÊýÖ¸Ê²Ã´ÄØ£¿¡¾Èç¹ûÊÇ30¸öÓû§¡¿
Óû§ÊýÁ¿30ÊÇ·ñÖ¸Á¬½Óµ½Êý¾Ý¿âµÄ¿Í»§¶ËÖ»ÓÐ30̨PC£¬»¹ÊÇÖ¸Êý¾Ý¿â¿ÉÒÔ°²×°µ½30̨PCÖУ¿
Çë´ó¼Ò°ïæ½â´ðһϣ¡

»¹ÓÐÒ»¸öÎÊÌ⣬ע²áµ½Êý¾Ý¿âÖеÄÓû§ÊýÕâ¸öÔõôÀí½ ......

ÈçºÎ²é¿´oracle¿ªÏú£¬»òÊÇsqlµÄÖ´ÐÐЧÂÊ

ÈçÌ⣺ÈçºÎ²é¿´oracle¿ªÏú£¬»òÊÇsqlµÄÖ´ÐÐЧÂÊ¡£
¡¾1¡¿Ôõô²é¿´Êý¾Ý¿âµ±Ç°ÔËÐжÔ×ÊÔ´µÄÕ¼ÓÃÇé¿ö£¬¾ßÌåÊÇÄǸöÈÎÎñÔÚÕ¼Óá£
¡¾2¡¿Ôõô²é¿´¾ßÌåsqlÓï¾äµÄÖ´ÐÐЧÂʺͶÔ×ÊÔ´µÄÕ¼Óã¬ÈçºÎµ¥¶À·ÖÎösqlµÄÓÅÂÔ¡£
Ï£Íû´ó¼Ò²ÎÓë½»Á÷£¡
¡¾1¡¿TOPÃüÁî
ÎÒÒ²²»ÊǺÜÇå³þ

ÒýÓÃ
ÈçÌ⣺ÈçºÎ²é¿´oracle¿ªÏú£¬»òÊÇsqlµÄÖ´ÐÐЧ ......

ORACLEÔõô×öµ½ÕâÑù£¿°ïÏÂæ

ID    Ãû×Ö    ÏúÊÛ¶î        »·±È
1    aa      20.2          0
1    aa      15.2      (15.2-20.2)/20.2
1    aa      23.0  ......

¹ØÓÚoracleÔ¶³ÌÁ¬½Ó¶ÔÏóµÄ·½°¸

»úÆ÷Ò»£º°üº¬ºÜ¶àÊý¾Ý¿â¶ÔÏó
Ä¿±ê£º½«ÕâЩÊý¾Ý¿â¶ÔÏóÇ¨ÒÆ³öÒ»²¿·Öµ½Ð»ú2
ÎÊÌ⣺ӦÓõÄÊý¾ÝÁ¬½Ó³ØÖ¸ÏòлúÒ»£¬µ«ÊÇ»¹ÐèÒª·ÃÎÊлú2ÖеÄÓ¦Óá£ÔÚ²»¸Ä±ä´úÂëµÄÇé¿öÏÂÈçºÎ½â¾ö
Àý:лú2Óиö¶ÔÏó½Ðtest
1¡£ÒòΪԭÀ´ËùÓжÔÏó¶¼ÔÚһ̨»úÆ÷ÉÏ£¬´úÂëÖвéѯÓï¾äÊÇÕâÑùµÄselect * from test.table;
2¡£²ð·ÖÍêÖ®ºóÈç¹ûÊ ......
×ܼǼÊý:1827; ×ÜÒ³Êý:305; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [224] [225] [226] [227] 228 [229] [230] [231] [232] [233]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ