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

oracleÁ·Ï°£¨mldnÊÓÆµ¿Î³Ì£©ËÄ

ÊÓͼ
´´½¨ÐÂ±í£ºcreate table emp2 as select * from emp;
create view empv20 as select empno,ename,job,hiredate,deptno from emp where deptno=20 with check option;
Óï·¨£ºcreate or replace view ÊÓͼÃû³Æ as ×Ó²éѯ£¨ÐÞ¸ÄÖ®ºóµÄ×Ó²éѯ£©
Ìæ»»ÊÓͼ(ÐÞ¸Ä)
create or replace view empv20 as select empno,ename,job,hiredate,deptno,sal from emp
where deptno=20 with check option;
Óï·¨£ºupdate ÊÓͼÃû set ¸üÐÂÄÚÈÝ Ìõ¼þ
¸üÐÂÊÓͼ
ÓÐÁ½¸ö²ÎÊý£ºwith check optionºÍwith read only
½«ÊÓͼÖеÄ7369Ö°Ô±µÄ²¿ÃźÅÐÞ¸ÄΪ30
update empv20 set deptno=30 where empno=7369;
´´½¨ÊÓͼʱÌí¼ÓÉÏwith check optionÔò²»»á¶Ô´´½¨Ìõ¼þ¸üУ¬µ«ÊÇ¿ÉÒÔ¶ÔÆäËû×ֶθüС£
ÈôÐÞ¸ÄÊÓͼÖÐ7369µÄÖ°Ô±ÐÕÃûΪ“Ê·ÃÜ˹”£¬¿É·ñÐ޸ģ¿
update empv20 set ename='Ê·ÃÜ˹' where empno=7369;
´´½¨ÊÓͼʱÌí¼ÓÉÏwith read onlyÔò²»»á¶Ô´´½¨Ìõ¼þ¸üУ¬
create view empv20 as select empno,ename,job,hiredate,deptno from emp where deptno=20 with read only;
ÒÔϲÙ×÷ʱÌáʾ²»ÔÊÐíÐéÄâÁУ¬ÊÇÖ»¶Á²Ù×÷
update empv20 set deptno=30 where empno=7369;
update empv20 set ename='Ê·ÃÜ˹' where empno=7369;
ÐòÁÐ
Óï·¨£ºcreate sequence ÐòÁÐÃû
·¶Àý£ºcreate sequence myseq
ʹÓÃÐòÁÐ
Á½ÖÖ²Ù×÷£ºnextval—È¡µÃÐòÁеÄÏÂÒ»¸öÄÚÈÝ
          currval—È¡µÃÐòÁеĵ±Ç°ÄÚÈÝ
insert into ±íÃû(ÁÐÒ»£¬Áжþ) values(±íÃû.nextval,±íÃû.currval)£»
ɾ³ýÐòÁУºdrop sequence ÐòÁÐÃû
Ôö³¤·ù¶È£ºincrement by ³¤¶È£¨·ÅÔÚ´´½¨ÐòÁеĺó±ß£©
·¶Àý£º1£¬´´½¨ÐòÁÐcreate sequence myseq
      2£¬´´½¨±ícreate table testseq(next number,curr number);
      3£¬Öظ´²åÈëÊý¾Ýinsert into testseq(next,curr) values(myseq.nextval,myseq.currval);
      4£¬²éѯÊý¾Ýselect * from testseq;
      ²éѯ³öÀ´µÄÊý¾ÝÒÔ²½³¤ÎªÒ»µÄËÙ¶ÈÔö¼Ó£¬ÈôÏëÒª²½³¤²»ÎªÒ»£¬ÔòÐèÒªÔÚ´´½¨ÐòÁÐʱ¼ÓÉÏincrement by n£¬nΪ²½³¤£¬
      Ó﷨Ϊ£ºcreate sequence ÐòÁÐÃû increment by n
²»ÄÜÐÞ¸ÄÒÑ´´½¨ÐòÁеIJ½³¤£¬Ö»ÄÜɾ³ýÐòÁÐÖØÐ´´½¨Ê±Ð޸IJ½³¤¡£
ĬÈÏÇé¿öÏÂÐòÁÐÊÇ´Ó1


Ïà¹ØÎĵµ£º

Oracle Data Gurad ÀíÂÛ֪ʶ


RAC£¬ Data Gurad£¬ Stream ÊÇOracle ¸ß¿ÉÓÃÐÔÌåϵÖеÄÈýÖÖ¹¤¾ß£¬Ã¿¸ö¹¤¾ß¼´¿ÉÒÔ¶ÀÁ¢Ó¦Óã¬Ò²¿ÉÒÔÏ໥ÅäºÏ¡£ ËûÃǸ÷×ԵIJàÖØµã²»Í¬£¬ÊÊÓó¡¾°Ò²²»Í¬¡£
RAC ËüµÄÇ¿ÏîÔÚÓÚ½â¾öµ¥µã¹ÊÕϺ͸ºÔؾùºâ£¬Òò´ËRAC ·½°¸³£ÓÃÓÚ7*24 µÄºËÐÄϵͳ£¬µ«RAC ·½°¸ÖеÄÊý¾ÝÖ»ÓÐÒ»·Ý£¬¾¡¹ ......

OracleÄÚÖýÇÉ«connectÓëresourceµÄȨÏÞ

Ê×ÏÈÓÃÒ»¸öÃüÁÓèuserÓû§connect½ÇÉ«ºÍresource½ÇÉ«£º
grant connect,resource to user;
ÔËÐгɹ¦ºóÓû§°üÀ¨µÄȨÏÞ:
CONNECT½ÇÉ«£º --ÊÇÊÚÓè×îÖÕÓû§µÄµäÐÍȨÀû£¬×î»ù±¾µÄ
ALTER SESSION --Ð޸ĻỰ
CREATE CLUSTER --½¨Á¢¾Û´Ø
CREATE DATABASE LINK --½¨Á¢Êý¾Ý¿âÁ´½Ó
CREATE SEQUENCE --½¨Á¢ÐòÁÐ
CREAT ......

OracleÖÐÖ»¸üÐÂÁ½Õűí¶ÔÓ¦Êý¾ÝµÄ·½·¨

OracleÖÐÖ»¸üÐÂÁ½Õűí¶ÔÓ¦Êý¾ÝµÄ·½·¨
ÏȽ¨Á¢Ò»¸ö½á¹¹Ò»Ä£Ò»ÑùµÄ±íemp1£¬²¢ÎªÆä²åÈ벿·ÖÊý¾Ý
create table emp1
as
select * from emp where deptno = 20;
updateµôemp1ÖеIJ¿·ÖÊý¾Ý
update emp1
set sal = sal + 100,
comm = nvl(comm,0) + 50
È»ºóÎÒÃÇÊÔ×ÅʹÓÃemp1ÖÐÊý¾ÝÀ´¸üÐÂempÖÐsal ºÍ commÕâÁ½ÁÐÊý¾Ý¡£
ÎÒÃ ......

ORACLEÈçºÎÍ£Ö¹Ò»¸öJOB

ORACLEÈçºÎÍ£Ö¹Ò»¸öJOB
1 Ïà¹Ø±í¡¢ÊÓͼ
2 ÎÊÌâÃèÊö
Ϊͬʽâ¾öÒ»¸öÒòÎªÍøÂçÁ¬½ÓÇé¿ö²»¼Ñʱ£¬Ö´ÐÐÒ»¸ö³¬³¤Ê±¼äµÄSQL²åÈë²Ù×÷¡£
¼ÈÈ»ÍøÂç×´¿ö²»ºÃ£¬¾ÍÑ¡ÔñÁËʹÓÃÒ»´ÎÐÔʹÓÃJOBÀ´Íê³É¸Ã²åÈë²Ù×÷¡£ÔÚJOBÖ´ÐÐÒ»¶Îʱ¼äºó£¬ÎÒ·¢ÏÖ±»²åÈë±íÓÐЩÎÊÌ⣨²ÑÀ¢£¬µ±Ê±Ò²Ã»ÓÐÏȼì²é¼ì²é¾Í×öÁË£©¡£×¼±¸Í£Ö¹JOB£¬ÒòΪÔÚJOBÔËÐÐÇé¿öÏ£¬ÎÒ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ