Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ż±È½Ï²Ë£¬ÏëÎÊÏÂOracleÆóÒµ¹ÜÀíÆ÷ÖÐÔõÑù²éѯÊý¾Ý°¡£¿

ÎÒÔõôֻÄÜ¿´µ½±íµÄÐÅÏ¢£¬¿´²»µ½¾ßÌåÊý¾ÝÄÇ£¿×¢£ºÅ¼ÖªµÀÔõôÓÃSQLÓï¾ä²é£¬ËùÒÔÇëÖ±½Ó¸æËßÎÒÔõôÔÚÆóÒµ¹ÜÀíÆ÷Öп´µ½Êý¾Ý¡£Ð»Ð»¸÷λ°ïæ¡£
ÆóÒµ¹ÜÀíÆ÷ûÓвéѯÊý¾ÝµÄµØ·½
½¨Òé×°Ò»¸öPL/SQL DEVELOPER»òÕßTOAD£¬ºÜºÃÓÃ
µ±È»,sqlplusÒ²²»´í

ÔÚEMÀïÑ¡ÖÐÄ¿±ê±í£¬ÓҲࡰ²Ù×÷¡±À¸µÄÏÂÀ­¿òÀÓС°²é¿´Êý¾Ý¡±Ñ¡ÏѡÔñÖ®£¬È»ºóµ¥»÷¡°¿ªÊ¼¡±°´Å¥£¬¼´¿É¿´¼û±íÄÚ¾ßÌåÊý¾Ý¡£

ѧϰÁË

Ôڲ鿴Êý¾ÝµÄͬʱ£¬Ò²¿ÉÊÇÉè¼Æ²éѯϸ½Ú£¬¼´¹ýÂËÌõ¼þ¡£°´ÕÕÒ³ÃæÌáʾÀ´×ö¡£

ÒýÓÃ
ÎÒÔõôֻÄÜ¿´µ½±íµÄÐÅÏ¢£¬¿´²»µ½¾ßÌåÊý¾ÝÄÇ£¿×¢£ºÅ¼ÖªµÀÔõôÓÃSQLÓï¾ä²é£¬ËùÒÔÇëÖ±½Ó¸æËßÎÒÔõôÔÚÆóÒµ¹ÜÀíÆ÷Öп´µ½Êý¾Ý¡£Ð»Ð»¸÷λ°ïæ¡£

oracleÀïÃæÃ»ÓÐÆóÒµ¹ÜÀíÆ÷°É£¬ÄãÔÚplsqlÀïÃæ¿ÉÒÔÓÃsql²éѯÓï¾ä¿´µ½µÄ¡£

»òÕßÔÙsqlplusÒ²¿ÉÒÔ¿´µ½µÄ¡£

2Â¥µÄ£¬Ê×ÏȸÐлÄãµÄ»Ø´ð¡£²»¹ýÎÒûÕÒµ½Å¶¡£ÎÒÓõÄÊÇ9I¡£

¶÷£¬ÎÒÒÔΪÄãÖ¸µÄÊÇ10g¡£


9iÔÚ±íÉϵãÓÒ¼ü£¬ºÃÏóÓиöʲô¡°ä¯ÀÀĿ¼ÄÚÈÝ¡±Ê²Ã´µÄÑ¡Ïî¡£ºÜ¾Ã²»ÓÃ9iÒÔ¼°ORACLEÆóÒµ¹ÜÀíÆ÷ÁË£¬Ó¡ÏóÄ£ºý¡£Äã×ÐϸÕÒÕÒÓÒ¼ü²Ëµ¥¡£

9iµÄÕâ¸öÕæÃ»ÓС£¡£¡£

ÎÞÂÛ9i»¹ÊÇ10g£¬ÆóÒµ¹ÜÀíÆ÷Àï¶¼¿ÉÒÔÖ±½Óä¯ÀÀ±íÊý¾Ý¡£

²»ÖªµÀÊDz»ÊÇÎÒÌ«±¿ÁË£¬Ã»ÓÐÕÒµ½¡£

Ī·ÇÕæµÄûÓÐÂð£¿

ºÇºÇ£¬ÎÒÔø¾­ÓÃËü²é¿´¹ý±íÊý¾Ý¡£¸æËßÎÒQ£¬Ô¶³ÌЭÖú£¬³ý·ÇÄã½øµÄ²»ÊÇÆóÒµ¹ÜÀíÆ÷¡£

9iÔÚÆóÒµ¹ÜÀíÖÐÓÒ¼ü±íÃû³Æ£¬Óиö¡°±íÊý¾Ý±à¼­Æ÷¡±ÀïÃæÓжÔÓ¦µÄÊý¾Ý~~~

ллsuiziguo£¬tianyihuyidao30£¬ÔÚÄãÃǵİïÖúÏÂÎÒÖÕÓÚÕÒµ½ÁË£¬ÔÚ9IÀïÓ¦¸ÃÊÇÓÒ¼ü²é¿´¡¢±à¼­Ä¿Â¼¡£


Ïà¹ØÎÊ´ð£º

oracle 10g webµÇ½EMµÄÎÊÌ⣿ - Oracle / »ù´¡ºÍ¹ÜÀí

°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿

1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......

oracle 10g°²×°µ½85%ʱ±¨´í

¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿

ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..

ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......

javaÔõôÁ¬½ÓOracle£¬¼±°¡ - Java / JavaÏà¹Ø

private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......

sqlÓÅ»¯ - Oracle / »ù´¡ºÍ¹ÜÀí

select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' 
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ