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

±±´óÇàÄñoracleѧϰ±Ê¼Ç26 27 28

Êý¾Ý¿â´¥·¢Æ÷
´¥·¢Æ÷Óï¾ä
    ÖÆ¶¨´¥·¢Æ÷¶¨Ê±¡¢Ê¼þ¡¢±íÃû¼°ÀàÐÍ
´¥·¢Æ÷Ö÷Ìå
    ÊÇpl/sql¿ì»ò¶Ô¹ý³ÌµÄµ÷ÓÃ
´¥·¢Æ÷ÏÞÖÆ
    ¿ÉÒÔͨ¹ýwhen×Ó¾äʵÏÖ
DML(insert update delete)
DDL(create alter drop)
Êý¾Ý¿â²Ù×÷(servererror logon logoff startup shutdown)

create trigger ´¥·¢Æ÷Ãû
before|after insert|delete|update of ÁÐÃû
on ±íÃû
[for each row]  --Ðм¶´¥·¢Æ÷
when Ìõ¼þ
´¥·¢Æ÷ν´Ê
inserting insert²Ù×÷
updating update²Ù×÷
deleting delete²Ù×÷
¿ÉÒÔ¸ù¾ÝÕâÈý¸öν´ÊÅжϵ½µ×ÔÚÖ´ÐÐÄĸö²Ù×÷
create or replace
Trigger tg_insert
before insert or update on student
for each row
begin
  if updating then
    dbms_output.put_line('before update');
  end if;
  if inserting then
    dbms_output.put_line('before insert');
  end if;
end;
´¥·¢Æ÷ÀàÐÍ£º   
1¡¢ ±í¼¶´¥·¢Æ÷£¨±í¼¶´¥·¢Æ÷¶Ôÿ¸öDMLÓï¾äÖ´ÐÐÒ»´Î)
create or replace Trigger tg_insert
before update on student
begin
  dbms_output.put_line('before update);
end;
4 rows updated
before update
2¡¢ Ðд¥·¢Æ÷ (Ðм¶´¥·¢Æ÷¶ÔDMLÓï¾äÓ°ÏìµÄÿ¸öÐÐÖ´ÐÐÒ»´Î)
create or replace
Trigger tg_insert
before update on student
for each row  --ÿÐд¥·¢Ò»´Î
begin
  dbms_output.put_line('before update');
end;
4 rows updated
before update
before update
before update
before update
ʹÓô¥·¢Æ÷ʱ£¬Á½¸öÌØÊâÖµ:new вåÈëµÄÖµ :old Ô­À´µÄÖµ  ²»ÄÜÓÃÓÚ±í¼¶´¥·¢Æ÷

 create or replace trigger trig_job
before insert or update of job
on emp
for each row
begin
if inserting then
:new.job:=upper(:new.job);
else
:new.job:=upper(:new.job);
end if;
end;
3¡¢INSTEAD OF´¥·¢(´Ë´¥·¢Æ÷ÊÇÔÚÊÓͼÉ϶ø²»ÊÇÔÚ±íÉ϶¨ÒåµÄ´¥·¢Æ÷,ËüÊÇÓÃÀ´Ìæ


Ïà¹ØÎĵµ£º

ORACLEÐÔÄÜÕï¶ÏʵÀý ÐÐÇ¨ÒÆºÍÐÐÁ´½Ó

ÃÀ¹úPVH DB´æÔÚÐÐÁ´½Ó.ͨ¹ýÎҵļì²é,·¢ÏÖ,ÎÒÃǵÄDBͬÑù´æÔÚÐÐÇ¨ÒÆºÍÐÐÁ´½Ó.ORACLEµÄdbms_stats.gather_schema_statsÖ»»áÊÕ¼¯ÓÅ»¯Æ÷ͳ¼ÆÐÅÏ¢,²»»á¼ì²â±íµÄ¼Ç¼ÊÇ·ñ´æÔÚÐÐÇ¨ÒÆºÍÐÐÁ´½Ó.(ÎÒÔ­Ïȱ»Õâ¸ö°ü¸øÆ­ÁË,ËùÒÔÖ´ÐÐÍêdbms_stats.gather_schema_statsºóÒ»²éÊý¾Ý×Öµä:USER_TABLES,ÆäÖеÄ×Ö¶Îchain_cntֵȫΪ0).Òª¼ì²â±íµÄ¼Ç ......

Oracle 10.2.0.1.0Éý¼¶µ½ 10.2.0.4.0

Ê×ÏÈÈ¥http://metalink.oracle.com ÏÂÔØÏà¹ØµÄ²¹¶¡°ü,ÒòΪÊÇ64λfor windowsµÄ°üÊÇp6810189_10204_MSWIN-x86-64.zip,ÏÂÔØµØÖ·:
ftp://updates.oracle.com/6810189/p6810189_10204_MSWIN-x86-64.zip
²Ù×÷ÈçÏÂ.
(1) OracleÍÆ¼öÔÚÉý¼¶Ö®Ç°ÏÈ×öÒ»¸öÈ«¿âµÄ±¸·Ý£»
(2) Í£Ö¹ËùÓеÄOracle·þÎñ
emctl stop dbconsole
isqlplusc ......

oracle±í·ÖÇøÏê½â


http://tianzt.blog.51cto.com/459544/171759   ½ö½ö¹©×Ô¼ºÑ§Ï°Ö®ÓÃ
´ËÎÄ´ÓÒÔϼ¸¸ö·½ÃæÀ´ÕûÀí¹ØÓÚ·ÖÇø±íµÄ¸ÅÄî¼°²Ù×÷:
        1.±í¿Õ¼ä¼°·ÖÇø±íµÄ¸ÅÄî
        2.±í·ÖÇøµÄ¾ßÌå×÷ÓÃ
        3 ......

OracleÒì³£ÎÊÌâ½â¾ö·½°¸


1. ÔÚ´ò¿ªEnterprise Manager Consolʱ±¨´í: "ÕÒ²»µ½Ä¿±êÖ÷»ú";
¡¾½â¾ö·½°¸¡¿¸ÃÎÊÌâÔÚʹÓÃGhostÖÆ×÷µÄϵͳÖг£¼û, ³ö´íÔ­ÒòÊÇOracleÖÐÅäÖõÄÖ÷»úÃû
 ºÍʵ¼ÊµÄÖ÷»úÃû²»Ò»ÖÂ. ½â¾ö·½·¨ÈçÏÂ: 
 (1) Enterprise Manager Consol -> ¹¤¾ß²Ëµ¥ ->·þÎñ¹ÜÀí -> Oracle Net Manager;
 (2) ½«"±¾µØ ......

´«ÖDz¥¿Í——Êý¾Ý¿âÖ®ORACLE£¨¶þ£©


¡¡¡¡1£© ÓÃSELECTÓï¾ä´Ó±íÖÐÌáÈ¡²éѯÊý¾Ý¡£Ó﷨Ϊ
¡¡¡¡SELECT [DISTINCT] {column1,column2,…} from tablename WHERE {conditions} GROUP BY {conditions} ORDER BY {expressions} [ASC/DESC]; 
¡¡¡¡ËµÃ÷£ºSELECT×Ó¾äÓÃÓÚÖ¸¶¨¼ìË÷Êý¾Ý¿âµÄÖÐÄÄЩÁУ¬from×Ó¾äÓÃÓÚÖ¸¶¨´ÓÄÄÒ»¸ö±í»òÊÓͼÖмìË÷Êý¾Ý¡£
¡¡¡¡2£© ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ