oracle ÊÓƵ±Ê¼Ç3(insert¡¢update¡¢delete)
Ò»,INSERT
1.ΪÁ˲»´òÂÒÔÀ´µÄ±íµÄÊý¾Ý,ËùÒÔ±¸·ÝÔÀ´µÄÊý¾Ý.
create table emp2 as select * from emp
create table emp3 as select * from emp
create table dept2 as select * from dept
create table salgrade2 as select * from salgrade
2.²é¿´±íµÄÉè¼ÆÇé¿ö:desc dept2;±íʾ²é¿´±ídept2µÄÉè¼ÆÇé¿ö.
3.²åÈëÊý¾ÝµÄ¸öÊýÓë±íµÄÊý¾ÝµÄ¸öÊýÒ»Ñù.
È磺insert into dept2 values (50, 'game', 'bj')
4.²åÈëÊý¾ÝµÄ¸öÊýÓë±íµÄÊý¾ÝµÄ¸öÊý²»Ò»Ñù.
È磺insert into dept2 (deptno, dname) values (60, 'game2')
5.Õû¸ö±íµÄ²åÈë¡£
È磺insert into dept2 select * from dept2; ,±íʾpept2±íÖеÄÊý¾ÝÖظ´²åÈëÁËÒ»±é¡£
4.Èç¹ûÊäÈë“rollback;”£¬ÔòÉÏÃæ²åÈëµÄÊý¾Ý¾Í»á»Ø¹ö¡£
¶þ,UPDATE
Èç:update emp2 set sal=sal*2, ename=ename||'-' where deptno = 10;
±íʾ°Ñ±íemp2ÖеÄdeptno = 10µÄsal³ËÒÔ2,ÔÚenameµÄºóÃæ¼ÓÉÏ"-"
Èý,DELETE
Èç:delete from emp2; ,±íʾ°Ñemp2Õâ¸ö±íÕû¸öɾ³ý
delete from dept2 where deptno <25; , ±íʾ°Ñ±ídept2 ÖеÄdeptnoСÓÚ25µÄÊý¾Ýɾ³ý.
Ïà¹ØÎĵµ£º
2009-11-15 13:06:35
½ñÌìÔÚITPUB·¢ÏÖһƪÎÄÕ£¬ÀÏÔçÒÔÇ°µÄÁË£¬Ð´µÄÂùÓÐÒâ˼£¬ÌØÒâת¹ýÀ´Êղء£
¶ÔÓÚ Oracle µÄ rownum ÎÊÌ⣬ºÜ¶à×ÊÁ϶¼Ëµ²»Ö§³Ö>,>=,=,between...and£¬Ö»ÄÜÓÃÒÔÉÏ·ûºÅ(<¡¢<=¡¢!=)£¬²¢·Ç˵ÓÃ>, >=,=,between..and ʱ»áÌáʾSQLÓï·¨´íÎ󣬶øÊǾ³£ÊDz鲻³öÒ»Ìõ¼Ç¼À´£¬»¹»á³öÏÖËƺ ......
ÕÒµ½Ò»¸ö½éÉÜoracle°æ±¾µÄÎÄÕ¡£
http://wapedia.mobi/en/Oracle_Database#3.
¡ö1979: Larry Ellison and friends founded Software Development Laboratories.
¡ö1979: SDL changed its company-name to "Relational Software, Inc." (RSI) and introduced its product Oracle V2 as an early commercially ......
µÚÒ»²¿·Ö¡¢SQL&PL/SQL
[Q]ÔõôÑù²éѯÌØÊâ×Ö·û£¬ÈçͨÅä·û%Óë_
[A]select * from table where name like 'A_%' escape ''
[Q]ÈçºÎ²åÈëµ¥ÒýºÅµ½Êý¾Ý¿â±íÖÐ
[A]¿ÉÒÔÓÃASCIIÂë´¦Àí£¬ÆäËüÌØÊâ×Ö·ûÈç&Ò²Ò»Ñù£¬Èç
insert into t values('i'||chr(39)||'m'); -- chr(39)´ú±í×Ö·û'
»òÕßÓÃÁ½¸öµ¥ÒýºÅ±íʾһ¸ö
or ......
select * from sys.smon_scn_time;
--scn Óëʱ¼äµÄ¶ÔÓ¦¹Øϵ
ÿ¸ô5·ÖÖÓ£¬ÏµÍ³²úÉúÒ»´Îϵͳʱ¼ä±ê¼ÇÓëscnµÄÆ¥Åä²¢´æÈësys.smon_scn_time±í¡£
select * from student as of scn 592258
¾Í¿ÉÒÔ¿´µ½ÔÚÕâ¸ö¼ì²éµãµÄ±íµÄÀúÊ·Çé¿ö¡£
È»ºóÎÒÃǻָ´µ½Õâ¸ö¼ì²éµã
insert into student select * from student a ......
oracleµÄ·ÖÎöº¯Êýover ¼°¿ª´°º¯Êý
Ò»£º·ÖÎöº¯Êýover
Oracle´Ó8.1.6¿ªÊ¼Ìṩ·ÖÎöº¯Êý£¬·ÖÎöº¯ÊýÓÃÓÚ¼ÆËã»ùÓÚ×éµÄijÖÖ¾ÛºÏÖµ£¬ËüºÍ¾ÛºÏº¯ÊýµÄ²»Í¬Ö®´¦ÊÇ
¶ÔÓÚÿ¸ö×é·µ»Ø¶àÐУ¬¶ø¾ÛºÏº¯Êý¶ÔÓÚÿ¸ö×éÖ»·µ»ØÒ»ÐС£
ÏÂÃæͨ¹ý¼¸¸öÀý×ÓÀ´ËµÃ÷ÆäÓ¦Óᣠ&nb ......