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

100·ÖÇó½âoracleÓйصÄ5¸öÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

ÈçÌâ:
1.ÈçºÎ²é¿´ºÍµ÷ÕûÊý¾Ý¿âµÄ×î´óÁ¬½ÓÊý£¿
2.linuxϲ鿴alert log?
3.ÔÚ×Ô¶¨ÒåµÄÀàÐͺóÃæ¼ÓÉÏindex by pls_integer ±íÊÇʲôÒâ˼£¿
4.oracleÖÐ×ÔÖÎÊÂÎñpragma autonomous_transaction µÄÀí½â£¿
5.Õâ¾ä»°ÔõôÀí½â£º
  Èç¹ûijһ²Ù×÷°üº¬´óÁ¿µÄSQL´úÂë»ò·Ö±ð±»¶à´ÎÖ´ÐУ¬ÄÇô´æ´¢¹ý³ÌÒª±ÈÅú´¦ÀíµÄÖ´ÐÐËÙ¶È¿ìºÜ¶à¡£ÒòΪ´æ´¢¹ý³ÌÊÇ
Ô¤±àÒëµÄ£¬ÔÚÊ״α»ÔËÐÐÒ»¸ö´æ´¢¹ý³Ìʱ£¬²éѯÓÅ»¯Æ÷¶ÔÆä½øÐзÖÎöÓÅ»¯£¬²¢¸ø³ö×îÖÕ±»´æÔÚϵͳ±íÖеÄÖ´Ðмƻ®¡£
¶øÅú´¦ÀíµÄSQLÓï¾äÔÚÿ´ÎÔËÐÐʱ¶¼Òª½øÐбàÒëºÍÓÅ»¯£¬Òò´ËËÙ¶ÈÏà¶ÔÒªÂýһЩ¡£


4. ×ÔÖÎÊÂÎñ£¬Ï൱ÓÚ¿ªÆôÁËÁíÒ»¸ö¶ÀÁ¢µÄÊÂÎñ£¬Õâ¸öÊÂÎñ²»ÊÜÖ÷ÊÂÎñµÄ¿ØÖÆ

5. 
¶øÅú´¦ÀíµÄSQLÓï¾äÔÚÿ´ÎÔËÐÐʱ¶¼Òª½øÐбàÒëºÍÓÅ»¯£¬Òò´ËËÙ¶ÈÏà¶ÔÒªÂýһЩ¡£
Õâ¸ö˵·¨ÊDz»¶ÔµÄ£¬Ç°¶ËÓ¦Óõ÷ÓÃÊý¾Ý¿âʱ¶¼ÓÐÀàËÆprepare()µÄ·½·¨£¬µ÷ÓÃÕâ¸ö·½·¨ºóÔÙ·´¸´Ö´ÐУ¬Ð§Âʸú´æ´¢¹ý³ÌÊÇÒ»ÑùµÄ¡£


ͬÒâÂ¥Éϵģ¬oracleûÄÇôÈõÖÇ£¬shared pool¾ÍÊÇÓÃÀ´´æ·Å½âÎö ¹ýµÄSQLÓï¾äµÄ¡£½ö½öÊÇ´ËSQLµÚÒ»´ÎÖ´ÐÐʱ´æ´¢¹ý³Ì±ÈÅú´¦Àí¿ì¡£µÚ¶þ´Î¡¢µÚÈý´Î¡£¡£¡£¾ÍÃ»Çø±ðÁË¡£
{{


Ïà¹ØÎÊ´ð£º

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 ......

server 2000Êý¾Ý×ªÒÆµ½oracle - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔ­À´oracleÀïµÄÔ­ÓеÄÊý¾Ý¿â,Ö»ÄÜн¨

ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......

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

select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' 
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......

oracleµÄ°²×°ºÍʹÓúÃÄѰ¡ - Java / Java EE

oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿Ô­À´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......

oracle adoÁ¬½ÓÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

ÔÚÁ¬½ÓÊý¾ÝԴʱ£¬Êý¾ÝÁ¬½ÓÊôÐÔÖÐÑ¡Ôñoracle provider for ole db
µ¥»÷ÏÂÒ»²½Ê±±¨´í ¡°Ìṩ³ÌÐò²»ÔÙ¿ÉÓã¬ÇëÈ·¶¨Ìṩ³ÌÐò±»ÕýÈ·°²×°¡£¡±
ÎÒÓõÄÊÇoracle 8£¬ÏÈǰÓõÄ10gÒ²Óöµ½ÀàËÆµÄÎÊÌâ
ʹÓÃmicrosoft ole db pro ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ