oracle ´¥·¢Æ÷¿ª·¢
´¥·¢Æ÷¿ª·¢µÄÄ¿µÄ£ºÈ·±£Êý¾Ý¿âÂú×ãÌØ¶¨µÄÉÌÒµ¹æÔòºÍÆóÒµÂß¼£¬¿ÉÒÔʹÓô¥·¢Æ÷£¬Ô¼Êø£¬×Ó³ÌÐò¡£ÒòΪ
Ô¼Êø×î¼òµ¥ÇÒÐÔÄܺã¬ËùÑ¡Ô¼Êø£¬Èç¹ûÔ¼Êø²»ÄÜÂú×㣬¾ÍÓô¥·¢Æ÷£¬Èô´¥·¢Æ÷¶¼²»ÄÜÂú×ãÑ¡Ôñ×Ó³ÌÐò¡£
Ò»¡¢´¥·¢Æ÷¹¦ÄÜ£º
1£¬¿ØÖÆÊý¾Ý°²È«,ÔÚ·þÎñÆ÷¼¶±ð¿ØÖÆÊý¾Ý°²È«ÊÇͨ¹ýÊÚȨºÍ»ØÊÕ¶ÔÏóȨÏÞÀ´Íê³ÉµÄ£¬±ÈÈçamsÓû§¶Ôscott/tiger Óû§¶Ô±íDML ²Ù×÷¡¢
grant select ,delete,update,insert on emp to ams;
µ«ÊÇΪÁËʵÏÖ¸ü¸´Ôӵݲȫģʽ£¬±ÈÈçÏÞÖÆ¶Ôij¸ö±íÒªÐ޸ĵÄÊý¾Ý£¬¾ÍÐèÒªÓõ½´¥·¢Æ÷£¬±ÈÈ磬ֻÓÐÔÚ9£º00µ½17£º00²ÅÄܸıäÊý¾Ý¿âEMP±í¶ÔÊý¾Ý¿â±í²Ù×÷
create or replace trigger triger_stat_before
before insert or update or delete on emp
declare
-- local variables here
begin
if (to_char(sysdate,'HH24') not between '9' and '17') then
RAISE_APPLICATION_ERROR(-20101,'·Ç¹¤×÷ÈÕʱ¼ä');
end if;
end triger_before;
2£¬ÊµÏÖÊý¾ÝÉ󼯣¬¼àÊÓ·Ç·¨ºÍ¿ÉÒɵÄÊý¾Ý»î¶¯£¬oracle ±¾ÉíÌṩÁËÉ󼯹¦ÄÜ¡£Èç¶Ôemp DML ²Ù×÷ÒÔºó£¬
°ÑSQL²Ù×÷µÄÐÅÏ¢(Óû§£¬Ê±¼äµÈ)дÈë×ֵ䡣µ«ÊÇÖ»ÄÜÉó¼Æsql ²Ù×÷£¬²»ÄܼÇÔØÊý¾Ý±ä»¯¡£Èç¹ûÒª¼ÇÔØÊý¾Ý
±ä»¯±ØÐëʹÓÃDML´¥·¢Æ÷¡£±ÈÈ繤×ʱ仯дÈëÊý¾Ý×Öµä±í¡£
--´´½¨×Öµä±í
drop table EMP_CHANGE;
create table EMP_CHANGE(
CNAME VARCHAR2(200),
OLDSAL NUMBER,
NEWSAL NUMBER,
CHANGE_TIME TIMESTAMP(6)
)
--´´½¨´¥·¢Æ÷
create or replace trigger triger_row_after
after update of sal on emp
for each row
 
Ïà¹ØÎĵµ£º
ÔÚÏîĿʵÏÖʱ£¬´ó¼ÒÒ»°ãÓбíµÄÉè¼Æ¡£ÓëÒ»°ãÊý¾Ý¿â²»Í¬£¬Oracle±í¿Õ¼äµÄ˵·¨¡£±í¿Õ¼äÒâΪ´æ·Å±íµÄ¿Õ¼ä¡£ÔÚ½¨Á¢±íµÄʱºòΪÁËÓëÔʼOracle±í¿Õ¼äÓÐÇø±ð£¬ÎÒÃÇ¿ÉÒÔ´´½¨Ðµıí¿Õ¼ä´æ·Å±í¡£Ò»°ãµÄ½¨ÒéÊǽ¨Á¢Á½¸ö±í¿Õ¼äÒ»¸ö´æ·ÅÊý¾Ý£¬Ò»¸ö´æ·ÅË÷Òý¡£
´´½¨Oracle±í¿Õ¼äµÄ·½·¨ÈçÏ£º
1.¿ÉÒÔͨ¹ýOracle×Ô´øµÄͼÐÎÓû§½çÃæÊµÏÖ¡£¾ßÌå ......
protected void BindData1()
{
OracleConnection orcn = new OracleConnection("User ID=wesoftwcp; Password=wesoft; Data Source=oradb");
orcn.Open();
&nb ......
OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹ÔÓ뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ©ÖÐÖ´Ð ......
ORACLE±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)
2007Äê11ÔÂ02ÈÕ ÐÇÆÚÎå 16:03
¸ÅÒª
1¡¢Á˽âʲôÊDZ¸·Ý
2¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
3¡¢Àí½âÊý¾Ý¿âµÄÁ½ÖÖÔËÐз½Ê½
4¡¢Àí½â²»Í¬µÄ±¸·Ý·½Ê½¼°ÆäÇø±ð
5¡¢Á˽âÕýÈ·µÄ±¸·Ý²ßÂÔ¼°ÆäºÃ´¦
Ò»¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
¿ÉÒÔ˵£¬´Ó¼ÆËã»úϵͳ³öÊÀµÄÄÇÌìÆð£¬¾ÍÓÐÁ˱¸·ÝÕâ¸ö¸ÅÄ ......