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µÄÊý¾Ýɾ³ý.
Ïà¹ØÎĵµ£º
ÕÒµ½Ò»¸ö½éÉÜ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 ......
1. ASCII
·µ»ØÓëÖ¸¶¨µÄ×Ö·û¶ÔÓ¦µÄÊ®½øÖÆÊý;
SQL> select ascii(A) A,ascii(a) a,ascii(0) zero,ascii( ) space from dual;
A A ZERO SPACE
--------- --------- --------- ---------
65 97 48 32
2. CHR
¸ø³öÕûÊý,·µ»Ø¶ÔÓ¦µÄ×Ö·û;
SQL> select chr(54740) zhao,chr(65) chr65 from ......
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 ......
ÊÂÎñ¾ÍÊDZ»°ó¶¨ÔÚÒ»Æð×÷Ϊһ¸öÂß¼¹¤×÷µ¥ÔªµÄSQLÓï¾ä·Ö×飬Èç¹ûÈκÎÒ»¸öÓï¾ä²Ù×÷ʧ°ÜÄÇôÕû¸ö²Ù×÷¾Í±»Ê§°Ü£¬ÒÔºó²Ù×÷¾Í»á»Ø¹öµ½²Ù×÷ǰ״̬£¬»òÕßÊÇÉÏÓиö½Úµã¡£ÎªÁËÈ·±£ÒªÃ´Ö´ÐУ¬ÒªÃ´²»Ö´ÐУ¬¾Í¿ÉÒÔʹÓÃÊÂÎñ¡£ÊÂÎñÓÐËĸöÌØÐÔ£¬·Ö±ðÊÇ£ºÔ×ÓÐÔ£¬Ò»ÖÂÐÔ£¬¸ôÀëÐԺͳ־ÃÐÔ¡£
Ë÷Òý¾ÍÒ»ÖÖÌØÊâµÄ²éѯ±í£¬Êý¾Ý¿âµÄËÑË÷ÒýÇæ¿ ......