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

ÆÀ:Å·ÃË×èÄÓOracle¼æ²¢Sun

 ËäÈ»ÎÒÃÇÖªµÀÉ̵À¹îÒ²,ÕâÆªÎÄÕ»¹ÊÇÄܹ»ÈÃÎÒÃÇ´ÓijЩ½Ç¶ÈÉϹ۲졣±ÈÈçÅ·ÃËÓµ»¤¿ª·Å¼¼Êõ,Å·ÃËÒªÆÀ¼ÛOracleÓµÓÐMySQLºÍJavaËùÔì³ÉµÄÓ°Ïì,everything is politicalÒÑÈ»ÊÇÒ»Ìõ´ó·¹æÔòÁË£¬ÎÒÃÇ»¹ÊÇÄܹ»Ðá³öÕâ¸ö»Ï×ÓÏÂÃæÂôµÃ»¹ÊÇÀûÒæ¹Ï·ÖµÄÀϾÀ¸ð£¬×ܲ»ÄÜɶºÃʶ¼ÈÃÄãÃÀ¹úÀÐÕ¼ÁË¡£µ«ÊÇÎÒÏëÒ²Ö»ÊǸöʱ¼äÎÊÌ⣬ҲÐí±³ºóÍÆÊÖÒªµÄ¾ÍÊÇʱ¼ä£¬Ò²Ðíʱ¼äÄܹ»¸øËü´­Ï¢µÄ»ú»á£¬À´»º³å´ËÊÂÔì³ÉµÄ³å»÷¡£·´¹ÛÎÒÃÇ£¬ÕæµÄÊǺÜÎÞÄΣ¬ÄÇЩ¼¼Êõ´óÅ£ÃÇ£¬É¶Ç°²ÅÄÜ¿¼ÂÇһϣ¬°ÑÖйúµÄÀûÒæ°ÚÉÏ×ÀÃæ£¬¶ø²»ÊǵÃÒâÑóÑóµØ¿´×ŰÑÎÕÀúÊ·µÄ»ú»áÔÚ×Ô¼ºÃæÇ°Ò»´Î´Î×ßÔ¶¡£
11.12ÔÚCSDN»Øhttp://news.csdn.net/a/20091112/214761.html
¸öÈË¿´·¨:Ê×ÏÈ£¬²»ÒªÐ¡ÇÆÁËMySQL£¬ÔÚÊý¾Ý¿âÐÐÒµËüÒ²ÊÇÒ»¸Ë´óÆì£¬ÓÐ×Ô¼ºÏÊÃ÷µÄÌØÉ«£¬ÓµÓÐÅÓ´óµÄÓû§Èº£»Æä´Î£¬Å·Ã˵ĽéÈëÒ»¶¨Óз¨ÀíÒÀ¾Ý£¬MySQLÔÚGPL±£»¤Ö®Ï£¬ËäÈ»ËüµÄGPL¹æ¶¨ÎÒ»¹Åª²»Çå³þ£¬µ«ÎÒÏëÅ·ÃÀÖ®¼äÓ¦¸ÃÓÐGPL·½ÃæµÄ֪ʶ²úȨ¹«Ô¼£¬MySQLÓÖÊÇÀ´Ô´ÓÚÅ·ÖÞ£¬ËùÒÔÅ·Ã˵ĽéÈë²¢ÎÞÒâÍ⣻ÔÙ¼ÓÉÏOracle×î½ü¼¸Ä꼫Ϊ½øÈ¡µÄ²¢¹º£¬ÔÚµ±Ï¾­¼ÃΣ»úÒõ»ê²»É¢µÄÇé¿öÏ£¬ËüÒѳÉΪITÐÐÒµÄËÖÁÕû¸ö¹¤Òµ½çµÄÁÁµãÁË¡£Å·ÖÞÒª±£»¤×Ô¼ºµÄÀûÒæ£¬µ«ÊÇÎÒÏëÕâÖÖ×÷Óû¹ÊÇÓÐÏ޵ģ¬Ò²¾ÍÊÇ˵ŷÃ˵ľöÒéûÓÐÇ¿ÖÆÐÔ£¬³ý·ÇOracleÒªÎÒÐÐÎÒËØ£¬Å·ÃËÄܹ»¶ÔÃÀ¹ú²ÉÈ¡±¨¸´¡£ËùÒÔÕâ¸ö»¹ÊǹØÏµµ½´ó¾ÖµÄ£¬ÊÇOracle±ØÐ뿼Âǵģ¬Æä¿¼Âǽá¹û£¬ÎÒ»¹ÊÇÈÏΪ»áÐγÉÍ×Э£¬×îÖÕÄܹ»Íê³É¹º²¢¡£²»¹ý£¬ÕâÏÂ×ÓOracleµÄÐÄÒª¾¾ÆðÀ´ÁË£¬¸Ð¾õ¾ÍÊÇËüµÄºêͼ´óÒµÔÚ³öÃÅÁÁÏàµÄÃż÷ÉÏÈøöÃŰÑÊÖ¸ø×§×¡ÁË¡£
¸öÈË¿´·¨£¬Å×שÒýÓñ¡£


Ïà¹ØÎĵµ£º

OracleÖÐÅúÁ¿µ¼³öSequence

 Ê¹ÓÃexp¹¤¾ß£¬ÒÔtablesµÄÀàÐ͵¼³öij¸öÓû§ÏÂËùÓеıíºÍÊý¾Ý£¬·¢ÏÖÆäÖÐsequenceûÓб»µ¼³ö¡£ÍøÉÏËÑË÷Ö®£¬·¢ÏÖtoadÃ²ËÆÓд˹¦ÄÜ£¬ÓÚÊǰ²×°ÁË9.6.1.1°æ±¾£¬½á¹û¾ÓȻû·¢Ïִ˹¦ÄÜ¡££¨¿ÉÄÜÊÇÎÒûÕÒµ½£¬ÖÁÉÙºÍÄÇλÀÏ´óµÄ½ØÍ¼²»Í¬£©£¬×îºóÕÒµ½ÈçϽű¾£¬¿ÉÒÔ½«Ä³¸öÓû§µÄÈ«²¿sequence²éѯ³öÀ´£¬²¢Æ´³É´´½¨Óï¾ä¡£
´úÂëÈçÏ£ ......

Oracle ´æ´¢¹ý³Ì

 
create or replace procedure p   //ÓоÍÌæ»»£¬Ã»Óоʹ´½¨
is
     cursor c is
         select * from emp for update;
begin
  for v_emp in c loop
      if (v_emp.deptno =10) then
 &nb ......

SQL ServerºÍOracleµÄ³£Óú¯Êý¶Ô±È

 ---------Êýѧº¯Êý
1.¾ø¶ÔÖµ
S:select abs(-1) value
O:select abs(-1) value from dual
2.È¡Õû(´ó)
S:select ceiling(-1.001) value
O:select ceil(-1.001) value from dual
3.È¡Õû£¨Ð¡£©
S:select floor(-1.001) value
O:select floor(-1.001) value from dual
4.È¡Õû£¨½ØÈ¡£©
S:select cast ......

OracleÖеÄcovering index

 CSDNÀïµÄÒ»¸öÅóÓÑÎʵ½ÁËÕâ¸öË÷Òý¸²¸ÇµÄ¸ÅÄî¡£ Õâ¸ö¸ÅÄîºÜСµÄ֪ʶµã£¬ÔÚÎÒµÄÂÛ̳ÀïÓнâÊÍ“”£¬²»¹ý×÷ΪOracle°æÖ÷£¬²»ÄÜÔÚ»ØÌûÀï¼ÓÉÏÍøÍâµÄµØÖ·Á´½Ó£¬ËùÒÔÕâÀïÔÚCSDNÀïÌûÉÏÒ»·Ý
±ÈÈçÓи´ºÏË÷ÒýΪ3¸ö×ֶΣºf1 + f2 + f3,ÇëÎÊ: 
1: select f1, f2, f3, f4 from table where f1 = 'XX' and f2 = 'XX'. ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ