OracleÖÐÀûÓÃTrigger½øÐй¤×÷
OracleÊý¾Ý¿âÖÐ,ÓÐЩÇé¿öÏÂ,¶ÔÊý¾Ý¼Ç¼ÐèÒª¼Ç¼ÈÕÖ¾,»ò±£´æ²Ù×÷ÀúÊ·µÈÇé¿ö.ÔÚ´ËÎÒÃÇ¿ÉÒÔ½èÖú“Êý¾Ý¿âTrigger”½øÐС£ÏÂÃæÒÔÒ»Àý½øÐÐ˵Ã÷£º
CREATE OR REPLACE TRIGGER aits_auth_group_auth_trga_diu
AFTER update OR DELETE OR INSERT on aits_authority_group_auth
for each row
/*****************************************************************************************
*
* Trigger Name : aits_auth_group_auth_trga_diu
* Description : Log insert, Modify ,delete action to History table
* Version : 1.0
*****************************************************************************************/
declare
BEGIN
IF inserting THEN
INSERT INTO aits_auth_group_auth_history
(application_code, auth_id, ranage_code,
group_code, module_code, function_code,
creation_date, created_by, last_update_date,
last_updated_by, action_type)
VALUES
(:new.application_code, :new.auth_id, :new.ranage_code,
:new.group_code, :new.module_code, :new.function_code,
:new.creation_date, :new.created_by, :new.last_update_date,
:new.last_updated_by, aits_pak_common.InsertDesc);
ELSIF DELETING THEN
INSERT INTO aits_auth_group_auth_history
(application_co
Ïà¹ØÎĵµ£º
Oracle sqlplusÔ¶³ÌÁ¬½ÓÊý¾Ý¿â
sqlplus username/password@yunSID_192.168.1.5
¹«Ë¾Ê¹ÓÃlinux¿ª·¢»ú½øÐгÌÐò¿ª·¢Ê±£¬ÓÉÓÚ¿ª·¢ÓÃOracleÊý¾Ý¿âÊÇÓÉÈÕ·½Ìṩ£¬ËùÒÔ¾³£Ê¹ÓÃsqlplusÁ¬½Óµ½Ô¶³ÌÊý¾Ý¿âÉϽøÐпª·¢,ÀýÈ磺
sqlplus username/password@servicename
ÓÚÊÇÏ룬ÓÃÎÒµÄÁ½Ì¨µçÄÔË«»ú»¥ÁªÊÔÒ»ÊÔ£¬Ò²Íæ¸ö&ldq ......
Ò»¡¢Æô¶¯
1.#su - oracle Çл»µ½oracleÓû§ÇÒÇл»µ½ËüµÄ»·¾³
2.$lsnrctl status ²é¿´¼àÌý¼°Êý¾Ý¿â״̬
3.$lsnrctl start &nb ......
OracleÊý¾ÝÀàÐͼò½é
¡¡¡¡Ò»¡¢¸ÅÊö
¡¡¡¡ÔÚORACLE8Öж¨ÒåÁË£º±êÁ¿£¨SCALAR£©¡¢¸´ºÏ£¨COMPOSITE£©¡¢ÒýÓã¨REFERENCE£©ºÍLOBËÄÖÖÊý¾ÝÀàÐÍ£¬ÏÂÃæÏêϸ½éÉÜËüÃǵÄÌØÐÔ¡£
¡¡¡¡¶þ¡¢±êÁ¿£¨SCALAR£©
¡¡¡¡ºÏ·¨µÄ±êÁ¿ÀàÐÍÓëÊý¾Ý¿âµÄÁÐËùʹÓõÄÀàÐÍÏàͬ£¬´ËÍâËü»¹ÓÐһЩÀ©Õ¹¡£ËüÓÖ·ÖΪÆß¸ö×飺Êý×Ö¡¢×Ö·û¡¢ÐС¢ÈÕÆÚ¡¢Ðбêʶ¡¢²¼¶ûºÍ¿É ......
ORACLEÊý¾Ý¿âµÄ»ù±¾Óï·¨¼¯½õ
-- ±í
create table test (names varchar2(12),
dates date,
&nb ......
Ò». µ¼³ö¹¤¾ß exp
1. ËüÊDzÙ×÷ϵͳÏÂÒ»¸ö¿ÉÖ´ÐеÄÎļþ ´æ·ÅĿ¼/ORACLE_HOME/bin
expµ¼³ö¹¤¾ß½«Êý¾Ý¿âÖÐÊý¾Ý±¸·ÝѹËõ³ÉÒ»¸ö¶þ½øÖÆÏµÍ³Îļþ.¿ÉÒÔÔÚ²»Í¬OS¼äÇ¨ÒÆ
ËüÓÐÈýÖÖģʽ£º
a. Óû§Ä£Ê½£º µ¼³öÓû§ËùÓжÔÏóÒÔ¼°¶ÔÏóÖеÄÊý¾ ......