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

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²ÎÊýnls_length_semantics

oracle²ÎÊýnls_length_semantics£º
ĬÈÏ£ºbyte
create table test  (a varchar(20),b number)
 µÈͬÓÚ£º
CREATE TABLE HXG.TESTNLS
(
  A  VARCHAR2(20 BYTE),
  B  NUMBER
)
varchar(20)ÓɲÎÊýnls_length_semantics¿ØÖÆ
/////////////////////////////////////////////////////// ......

oracleÖÐ ÕýÔÚÁ¬½Ó...ORA 12541: TNS: ûÓмàÌý³ÌÐò

¶ÔÓÚ×°ºÃÁ˸ÃÈí¼þºó,ÀûÓÃsystemÊÇÄܵǽøÈ¥µÄ,»ú×ÓÖØÆôºó,³öÏֵĸÃÎÊÌ⣺
    ¿ÉÄÜÄú ÔËÐÐ--sqlplusw  ÊÇÄܵÇÉÏÈ¥µÄ  ¶ø»»³ÉPL/SQL Developer È´Á¬²»ÉÏ ·þÎñÆ÷,Èç¹ûÄúÈ·¶¨ÄãµÄ·þÎñ¿ªÆôÁË
    ËÑË÷ÕÒµ½tnsnames.oraºÍlistener.oraÎļþ, °ÑÆäÖеÄHOST=ºóµÄÖ÷»úÃû»òip¸ÄΪµ±Ç°µ ......

oracle for linux°²×°

ÕÛÌÚÁËÁ½¸öÍíÉϵÄlinuxºÍoralce£¬×ÜËã³öÀ´µã¶«Î÷ÁË¡£Oralce°²×°ÒªÑ¡ÓÃÊÊÓõİ汾£¬²»È»°²×°²»»á³É¹¦£¬×îºóÎҵľö¶¨ÊÇlinuxÑ¡ÓÃcentos 5.0£¬oracleÑ¡ÓÃ10¡£
Ò»¡¢        ×¼±¸¹¤×÷£º
1.       ʹÓÃrootÓû§µÇ¼
ÎÒʹÓõÄÊÇÔÚ±¾»ú×°£¬ËùÒÔÖ±½Ó´ò¿ªÖÕ¶Ë¾Í ......

ORACLEÊý¾Ý¿â±¸·Ý·½·¨

OracleÊý¾Ý¿âÓÐÁ½À౸·Ý·½·¨¡£µÚÒ»ÀàΪÎïÀí±¸·Ý£¬¸Ã·½·¨ÊµÏÖÊý¾Ý¿âµÄÍêÕû»Ö¸´£¬µ«Êý¾Ý¿â±ØÐëÔËÐÐÔڹ鵲ģʽÏ£¨ÒµÎñÊý¾Ý¿âÔڷǹ鵲ģʽÏÂÔËÐУ©£¬ÇÒÐèÒª¼«´óµÄÍⲿ´æ´¢É豸£¬ÀýÈç´Å´ø¿â£»µÚ¶þÀ౸·Ý·½Ê½ÎªÂß¼­±¸·Ý£¬ÒµÎñÊý¾Ý¿â²ÉÓôËÖÖ·½Ê½£¬´Ë·½·¨²»ÐèÒªÊý¾Ý¿âÔËÐÐÔڹ鵲ģʽÏ£¬²»µ«±¸·Ý¼òµ¥£¬¶øÇÒ¿ÉÒÔ²»ÐèÒªÍⲿ´æ´¢É豸 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ