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

oracle ÊÓͼ´¥·¢Æ÷

CREATE OR REPLACE TRIGGER t_mbaxs_update
INSTEAD OF update on v_xsjbxx
FOR EACH ROW

BEGIN
  update t_mbaxs set name=:new.xm where xh=:new.xh;
END;


ÊÓͼÖÐÊý¾ÝÒÑ·¢Éú±ä»¯¡£µ«t_mbaxsÕâÕűíÖеÄÊý¾ÝȴûÓз¢Éú¶ÔÓ¦µÄ±ä»¯
Êý¾Ý±ä»¯ÊǸüÐÂ±í¶ø²»ÊǸüÐÂÊÓͼÒýÆðµÄ°É
´¥·¢Æ÷²»»á±»´¥·¢

Â¥Ö÷£¬²»ÖªµÀÄãµÄΪʲô²»ÐУ¬ÎÒµÄÄܳɹ¦

»¹ÓÐ ÄãµÄv_xsjbxx ºÍ t_mbaxsÖ®¼äµÄ¹ØÏµÊÇʲô£¿

˵Ã÷°×µã ¿ÉÄÜ»¹Çå³þµã

ÊÓͼÊý¾Ý±ä»¯²»ÊÇÖ¤Ã÷Êý¾ÝÒѾ­±»ÐÞ¸ÄÁËÂð£¿
²»Ã÷°×ÄãµÄ±íÊý¾ÝÔõô»áû±ä£¿ÊDz»ÊÇÄãûˢа¡£¿

update t_mbaxs set name=:new.xm where xh=:new.xh;
ÄãµÄÕâ¸öupdateÓï¾äÓÐÎÊÌâ°É£¿

¸Ä³Éupdate t_mbaxs set name=:new.xm where xh=:old.xh;
ÔÙÊÔÒ»ÏÂ

ÒýÓÃ
Êý¾Ý±ä»¯ÊǸüÐÂ±í¶ø²»ÊǸüÐÂÊÓͼÒýÆðµÄ°É
´¥·¢Æ÷²»»á±»´¥·¢

Ó¦¸ÃÊÇÕâ¸öÔ­Òò°É

ÒýÓÃ
¸Ä³Éupdate t_mbaxs set name=:new.xm where xh=:old.xh;
ÔÙÊÔÒ»ÏÂ
Ö»ÓÐÓÃdelete²Ù×÷ʱ²Å»áÓÃ:old.xh°É


Ïà¹ØÎÊ´ð£º

linuxÏÂCÓïÑÔ¿ª·¢oracleµÄÎÊÌâ¡£

Á½¸öÎļþ1.PC£¬1.inc
1.PCÓвÙ×÷oracleÊý¾Ý¿âµÄ ,1.incÒ²ÓвÙ×÷oracleÊý¾Ý¿â 
ÔÚÆäËûÊý¾ÝÖÐÈçinformix ÖÐ$include 1.inc¾Í¿ÉÒÔʹÓÃÁË
ÔÚORACLEÊý¾Ý¿âÖØ $include 1.inc²»¿ÉÓà EXEC SQL include 1.incÒ²²»¿É ......

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

oracleÓëaix - Oracle / ¸ß¼¶¼¼Êõ

ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼­¾íºÅlv04 
#lslv -l lv04 ......

oracle 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......

[Ô­´´] ORACLE Á¬½Ó×Ö´® - Oracle / ·Ç¼¼ÊõÇø

¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰 
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ