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

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ËùÓа汾»ã×Ü

ÕÒµ½Ò»¸ö½éÉÜ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 ......

110¸öoracle³£Óú¯Êý×ܽá

 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 ......

oracle »Ö¸´±íµ½ÒÔÇ°µÄij¸ö״̬

 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 ±Ê¼Ç VIII Ö®ÊÂÎñºÍË÷Òý

 ÊÂÎñ¾ÍÊDZ»°ó¶¨ÔÚÒ»Æð×÷Ϊһ¸öÂß¼­¹¤×÷µ¥ÔªµÄSQLÓï¾ä·Ö×飬Èç¹ûÈκÎÒ»¸öÓï¾ä²Ù×÷ʧ°ÜÄÇôÕû¸ö²Ù×÷¾Í±»Ê§°Ü£¬ÒÔºó²Ù×÷¾Í»á»Ø¹öµ½²Ù×÷ǰ״̬£¬»òÕßÊÇÉÏÓиö½Úµã¡£ÎªÁËÈ·±£ÒªÃ´Ö´ÐУ¬ÒªÃ´²»Ö´ÐУ¬¾Í¿ÉÒÔʹÓÃÊÂÎñ¡£ÊÂÎñÓÐËĸöÌØÐÔ£¬·Ö±ðÊÇ£ºÔ­×ÓÐÔ£¬Ò»ÖÂÐÔ£¬¸ôÀëÐԺͳ־ÃÐÔ¡£
Ë÷Òý¾ÍÒ»ÖÖÌØÊâµÄ²éѯ±í£¬Êý¾Ý¿âµÄËÑË÷ÒýÇæ¿ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ