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

oracleµÄ¶Áд±í²¢·¢²Ù×÷

 k Ëµ(14:52):
ÎʸöÎÊÌâ ²éѯÊý¾Ý¿â±íµÄʱºò ¸Ã±í»¹ÄÜдÊý¾ÝÂð  ÊÇ°´ÕÕÅŶӵÄ˳Ðò »¹ÊÇ°´ÕÕ²Ù×÷µÄʱ¼ä˳Ðò(²»ÖªµÀoracleÈçºÎ´¦ÀíÕâ¸öÎÊÌ⣩  ¼ÙÉèÒ»¸öÇé¿ö£ºÎÒÏÖÔÚÔÚ²éѯ¼Æ·Ñ±í£¨Õâ¸öʱ¼ä¿ÉÄÜÒª»¨10·ÖÖÓ£© 10·ÖÖÓÓкܶà¼Æ·ÑÊý¾ÝÒªÈë¼Æ·Ñ±í£¨ÄÇÕâ¸öдÊý¾ÝÊÇÒªµÈÎÒ²éѯÍêÁËÖ®ºó²ÅÄÜдÂ𣩠дÊý¾Ý¿â¿Ï¶¨ºÜ¿ì£¨0.1Ã루»¹ÊÇÀ´ÁËÊý¾Ý¾Íд£© ²éѯÒÀÈ»²éѯд֮ǰµÄÊý¾Ý
m˵(14:54):
ÄÜд
m1˵(14:54):
ÄãÓÃselect .... for update nowait ºÃÏñÊÇ ÎÒÍüÁ˾ßÌåÔõôдÁË£¬ÕâÑù¾Í¿ÉÒÔËø±íÁË£¬µÈÄã²éÍêÁËÌá½»ºó±ðÈ˲ÅÄܸüÐÂ
m˵(14:55):
¸úÊÂÎV±ðÓйØϵ
m˵(14:55):
²¢·¢¼¶±ðÉèÖÃ
m3 Ëµ(14:56):
²éѯʱºòǧÍò±ðËø±í
k Ëµ(14:59):
ÎÒÏÖÔÚÒ²¾õµÃÄÜд ÒòΪÎÒ²éѯ±¨±í¿â ¶©¹º±í Êý¾Ý³öÀ´µÄºÜ¿ì£¨597.797Ãë) ÏÖÔÚÎÒ²éÏÖÍø¿â »¨ÁË 1184.062Ãë  ÕâÖÐ;¿Ï¶¨Ð´Êý¾ÝÈ¥ÁË 
m ˵(14:59):
ÄÜд
m˵(14:59):
²éѯ£¬Ð´È붼ÊDz¢·¢µÄ
ÏÖÔÚÓÐеÄÎÊÌ⣬¼ÈÈ»²éѯÊý¾ÝµÄʱºòÒ²ÔÚдÊý¾Ý£¬ÄÇôÎҵIJéѯ³¡¾°Ó¦¸ÃÊÇд֮ǰµÄ³¡¾°£¬ÒòΪÈç¹ûдһ´ÎÊý¾Ý£¬ÎÒÓÖ´ÓÍ·¿ªÊ¼²éѯ£¬ÄÇÎҵIJéѯ¾ÍÍê³É²»ÁËÁË¡£ËùÒÔoracleÓ¦¸ÃÊÇÓÃÁË»º³åÊý¾ÝµÄ¹¦ÄÜ£¬²éѯµÄ¹ý³ÌÖУ¬ÏÈ°ÑдÈëµÄÊý¾Ý·Åµ½»º³åÇøÀµÈ²éѯÍê±ÏÁË£¬ÔÚдÈë±í¿Õ¼äÀï¡££¨²»ÖªµÀÊDz»ÊÇÕâÑù£¬¶ÔÊý¾Ý¿â²»ÊǺÜÁ˽⣬ÕâÊÇÎÒµÄÒ»¸öÏë·¨¶øÒÑ£¬×Ô¼º¾õµÃ»¹Óеã¶ùµÀÀí£©


Ïà¹ØÎĵµ£º

OracleÊý¾Ýµ¼Èëµ¼³öimp/expÃüÁî

OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹Ô­Ó뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
 
Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ©ÖÐÖ´Ð ......

ORACLEº¯Êý´óÈ«

LONEFOXÌâ¼Ç£º
×î½ü¸ãORACLE£¬ ת¹ýÀ´¹©²Î¿¼¡£
=================================
1¡¢SQL Óï¾ä»ù´¡
ÏÂÃæ¸ø³öSQLÓï¾äµÄ»ù±¾½éÉÜ¡£
1.1¡¢SQLÓï¾äËùÓ÷ûºÅ
²Ù×÷·û
 ÓÃ;
 Àý×Ó
 
+ -
 ±íʾÕýÊý»ò¸ºÊý£¬ÕýÊý¿ÉÊ¡È¥ +
 -1234.56
 
+
 ½«Á½¸öÊý»ò±í´ïʽ½øÐÐÏà¼Ó
 A=c+b ......

Oracle All And Any

ת£ºOracle All And Any
    ÕâÊÇÔÚOracleÖбȽÏÈÝÒ×±»ºöÊÓµÄÁ½¸öÌõ¼þº¯Êý£¬µ«ÕâÁ½¸öº¯ÊýÆäʵ¶Ô¼ò»¯SqlÓï¾äÊǷdz£ÖØÒªµÄ×÷Óõġ£
¡¡¡¡ÀýÈç
scott@eddev> select ename, sal  from emp  where sal > any (1600, 2999);
ENAME         &nb ......

oracleÓÅ»¯ »º´æ¶ÔÏóÓëÊý¾Ý

author£ºskate
time£º2010/03/16
µ±ÏµÍ³³öÏÖÐÔÄÜÆ¿¾±Ê±£¬¾¡Á¿½ÏÉÙ²»±ØÒªµÄ×ÊÔ´ÏûºÄ£¬×îºó¾ÍÊÇƽºâcpu£¬Äڴ棬io£¬networkµÈ×ÊÔ´£¬Ê¹Êý¾Ý¿â
¿ÉÒÔÎȶ¨µÄÔËÐС£
oracleÊý¾Ý¿âÓÅ»¯µÄ¸ù±¾ÊÇ
1.¾¡Á¿¼õÉÙ×ÊÔ´ÏûºÄ£¬ÀýÈçÓÅ»¯sql£¬¼õÉÙsql±¾ÉíµÄ×ÊÔ´ÏûºÄ
2.Èç¹ûÎÞ·¨½øÒ»²½¼õÉÙ×ÊÔ´µÄÏûºÄ£¬ÄǾÍÈÃÊý¾Ý¾¡Á¿¿¿½ücpu£¬Ò²¾ÍÊÇ°ÑÊý¾Ý ......

ORACLEÀàËÆsplitº¯ÊýµÄ¹¦ÄÜ

 SELECT ID,
       col_name,
       SUBSTR(col_name, 1, INSTR(col_name || ',', ',', 1, 1) - 1) C1,
       SUBSTR(col_name,
              ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ