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

½ñÌìµÄ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¡¢ÒòΪһ´ÎÐÔÐ޸ĵÄÊý¾ÝÌ«¶à£¬¶øµ¼Ö»عö¶Î¡¢ÁÙ


Ïà¹ØÎÊ´ð£º

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

[Ô­´´] ORACLE Á¬½Ó×Ö´® - Oracle / ·Ç¼¼ÊõÇø

¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰 
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN ......

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

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

OracleÖв鿴×Ô¼º´´½¨µÄ±í - Oracle / ¸ß¼¶¼¼Êõ

Ôõôͨ¹ýÃüÁî²é¿´×Ô¼ºÒѾ­´´½¨µÄ±í£¿
select tname from tab;

SQL code:

--1.sysÓû§µÇ¼
select table_name
from dba_indexes
where table_owner = 'Óû§Ãû';
--2.ËùÓÐÓû§
select * from tab; ......

oracle ´æ´¢¹ý³Ì¸Ä³É ÊÂÎï Ôõôд°¡ - Oracle / ¿ª·¢

CREATE OR REPLACE PROCEDURE usp_refreshTopN
 IS
 BEGIN
 
--Îĵµ
INSERT INTO topnresource(resourceId,title,type,cover,brief,properUser,tag,clickAmount,createDate,topNCreateDate,o ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ