½ñÌìµÄoracleÃæÊÔÌâ - Oracle / »ù´¡ºÍ¹ÜÀí
1¡¢ÓÐÒ»ÕűíA,ÊôÐÔÓÐId ,name ,ageÕâÕűíµÄÊý¾ÝÁ¿´ïµ½100Íò£¬Òª°ÑËùÓеÄage¶¼¸üÐÂΪage+1£¬ÇëÎÊÔõôʵÏÖ×î¸ßЧ£¿
¸ßЧ£¿×øµÈ´óÏÀ ÎҾͻáÕâÑùupdate table_name set num=num+1 ; Äã¿ÉÒԻش𣬱íÉè¼Æ²»ºÃ£¬age»áËæ×Åʱ¼ä±ä»¯¶ø±ä»¯£¬¸ÄÓÃbirthday£¬ÓÃdateÀàÐͰÉÒýÓà Äã¿ÉÒԻش𣬱íÉè¼Æ²»ºÃ£¬age»áËæ×Åʱ¼ä±ä»¯¶ø±ä»¯£¬¸ÄÓÃbirthday£¬ÓÃdateÀàÐꡃ Õâ¸öÊÇÃæÊÔÌ⣬Äã¾Í²»Òª¿¼ÂÇÉè¼ÆÎÊÌâÁË£¬¾Í°Éageµ±³É¸öÆÕͨµÄintÀàÐ͵ÄÁУ¬°ÑËûÈ«²¿¼Ó1¡£ 100ÍòÒ²Ó¦¸ÃºÜ¿ì°É update table_name set num=num+1 Èç¹ûÓÐË÷Òý£¬ÏȰÑË÷Òýɾ³ýºó ÔÙupdate ×îºó°ÑË÷ÒýÖØÐ´´½¨Ò»Ï ÒòΪË÷Òý¶ÔupdateÓ°ÏìºÜ´óÒýÓà Èç¹ûÓÐË÷Òý£¬ÏȰÑË÷Òýɾ³ýºó ÔÙupdate ×îºó°ÑË÷ÒýÖØÐ´´½¨Ò»Ï ÒòΪË÷Òý¶ÔupdateÓ°ÏìºÜ´ó ͬÒâÕâÖÖ×ö·¨... ÖØ½¨Ë÷ÒýºÜ¿ì... SQL code: --ÔÚÔÊÐíµÄÇé¿öÏ¿ÉÒÔ 1¡¢create table newA as select id,name,age+1 age from A; 2¡¢drop table A; 3¡¢rename newA to A; ÓÐûÓÐÈËÓÃÅúÁ¿¸üвÙ×÷ѽ ΪʲôÕâÑùºÜµÍЧ£¿ update table_name set num=num+1 ÕâÒ²ÓиãÍ·? ÅúÁ¿¸üÐÂß ÉèÖÃ×Ô¶¯Ìá½»ÐÐÊý£¬»á¿ìºÜ¶à set autocommit 1000; update table_name set age=age+1; dml ²Ù×÷µÄȱµã£º 1¡¢ÒòΪһ´ÎÐÔÐ޸ĵÄÊý¾ÝÌ«¶à£¬¶øµ¼Ö»عö¶Î¡¢ÁÙ
Ïà¹ØÎÊ´ð£º
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ emp_no emp_name ------- ------------ 0001 TOM 0002 JOHN 0003 MARY ³£Óõ绰 ¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput) 0001,TOM 0002,JOHN
......
oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿ÔÀ´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......
Ôõôͨ¹ýÃüÁî²é¿´×Ô¼ºÒѾ´´½¨µÄ±í£¿ select tname from tab; SQL code: --1.sysÓû§µÇ¼ select table_name from dba_indexes where table_owner = 'Óû§Ãû'; --2.ËùÓÐÓû§ select * from tab;
......
CREATE OR REPLACE PROCEDURE usp_refreshTopN IS BEGIN --Îĵµ INSERT INTO topnresource(resourceId,title,type,cover,brief,properUser,tag,clickAmount,createDate,topNCreateDate,o ......