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µÄÊý¾Ýɾ³ý.
Ïà¹ØÎĵµ£º
¡¾ÒýÓá¿http://tangshd.blog.sohu.com/96035768.html
Oracle¶àÐмǼºÏ²¢/Á¬½Ó/¾ÛºÏ×Ö·û´®µÄ¼¸ÖÖ·½·¨
ÔõôºÏ²¢¶àÐмǼµÄ×Ö·û´®£¬Ò»Ö±ÊÇoracleÐÂÊÖϲ»¶ÎʵÄSQLÎÊÌâÖ®Ò»£¬¹ØÓÚÕâ¸öÎÊÌâµÄÌû×ÓÎÒ¿´¹ý²»ÏÂ30¸öÁË£¬ÏÖÔھͶÔÕâ¸öÎÊÌ⣬½øÐÐÒ»¸ö×ܽᡣ
ʲôÊǺϲ¢¶àÐÐ×Ö·û´®£¨Á¬½Ó×Ö·û´®£©Ä ......
ÕÒµ½Ò»¸ö½éÉÜ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.ÀûÓÃÏÂÃæµÄ½Å±¾´´½¨BOOK£¬READER ºÍ BORROW ±í£¬²¢Íê³ÉºóÃæµÄÁªÏµ¡£
CREATE TABLE BOOK(
NO CHAR(8) PRIMARY KEY,
TITLE VARCHAR2(50) NOT NULL,
AUTHOR VARCHAR2(20) ,
PUBLISH VARCHAR2(20),
PUB_DA ......
ÏÂÃæÊÇÓÃscottÓû§²âÊԵġ£
Èç¹û²»ÖªµÀµ±Ç°Óû§ÊÇʲôÓû§,¿ÉÒÔÊäÈë: show user ,ÕâÑùËü¾ÍÏÔʾ³öµ±Ç°Óû§ÊÇʲôÓû§ÁË.
Èç¹ûÏë±à¼ÒѾÊäÈëµ½sqlplusÖеĴúÂë,¿ÉÒÔÊäÈë“ed”£¬È»ºó»Ø³µ¾ÍÄܵ¯³öÒ»¸ö¼Çʱ¾£¬¼Çʱ¾ÀïÃæÓÐÉÏÒ»²½ÊäÈëµÄ´úÂë,Ð޸ĴúÂë²¢±£´æºó¹Ø±Õ¼Çʱ¾,×îºóÔÚsqlplusÖÐÊäÈë“/”²¢»÷»Ø ......