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

¹ØÓÚoracle´¥·¢Æ÷µÄÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

ÏÖÔÚÓÐÈý¸ö±íA£¬B£¬C,±íÖÐ×Ö¶ÎÈçÏ£º
±íA£º[×Ö¶Î1][×Ö¶Î2][×Ö¶Î3][×Ö¶Î4]
±íB£º[×Ö¶Î1][×Ö¶Î2]
±íC£º[×Ö¶Î3][×Ö¶Î4]
ÒªÇóµ±±íAÖ´ÐÐinsert²Ù×÷ʱ£¬Ïò±íBºÍ±íCÖвåÈëÏàÓ¦×ֶΣ¬ÆäÖÐ×Ö¶Î1ºÍ×Ö¶Î2²åÈë±íB£¬×Ö¶Î3ºÍ×Ö¶Î4²åÈë±íC
ÇëÎÊ´¥·¢Æ÷¸ÃÔõôд°¡£¿
ÎÒ³¢ÊÔ×ÅÔÚÒ»¸ö´¥·¢Æ÷ÁËдÁËÁ½ÌõinsertÓï¾ä£¬µ«ÊÇûÓÐÖ´Ðгɹ¦¡£

SQL code:
CREATE OR REPLACE TRIGGER tr_A_insert
AFTER INSERT ON table_A
FOR EACH ROW
BEGIN
--ʹÓÃ:newÀ´ÒýÓÃвåÈëÖµ
INSERT INTO ±íB VALUES (:new.×Ö¶Î1, new.×Ö¶Î2);
INSERT INTO ±íC VALUES (:new.×Ö¶Î3, :new.×Ö¶Î4);
END;



´¥·¢Æ÷£º
create or replace trigger asdf
after insert on A
  
for each row
 
begin
insert into B values (:new.×Ö¶Î1,:new.×Ö¶Î2);
insert into C values(:new.×Ö¶Î3,:new.×Ö¶Î4);
end;

ÄÇÄãµÄ´¥·¢Æ÷Óï¾äÌù³öÀ´¿´¿´
±¨Ê²Ã´´í

SQL code:

create or replace trigger in_a before insert on A for each row
as
begin
insert into B values(:new.×Ö¶Î1,:new.×Ö¶Î2);
insert into C values(:new.×Ö¶Î3,:new.×Ö¶Î4);
commit;
end;

--2:Ò²¿ÉÒÔÓÃmerge intoÀ´
merge into B using A on(A.×Ö¶Î1=B.×Ö¶Î1 and A.×Ö¶Î2=B.×Ö¶Î2)
when not matched then insert(B.×Ö¶Î1,B.×Ö¶Î2) values(A.×Ö¶Î1,A.×Ö¶Î2)


merge into C using


Ïà¹ØÎÊ´ð£º

oracle²¢·¢´¦ÀíSOS - Oracle / ¿ª·¢

ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾ­ºÜ³ÉÊìÁË

ÒýÓÃ
oracle ......

OracleµÄblob×Ö¶ÎÎÊÌâ - Oracle / ¿ª·¢

²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×Å°ïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......

JavaÖ®¸¸À뿪Oracle£¬±¯Í´°¡£¡£¡ - Java / ·Ç¼¼ÊõÇø

¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬
ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡
OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Âð£¿
SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......

OracleÁÙʱ±íʹÓÃÎÊÌâ - Oracle / ¿ª·¢

ÎҵĴ¦ÀíÊÇÕâÑùµÄ£º
ÎÒÓÐÒ»¸öºÜ´óµÄÊý¾Ý¼¯ºÏ£¬´¦ÓÚÐÔÄÜ·½ÃæµÄ¿¼ÂÇÐèҪʹÓÃÁÙʱ±í¹ý¶É£¬²¢ÇÒʹÓ÷ÖÒ³µÄ·½Ê½ÏòÁÙʱ±íÖвåÈëÊý¾Ý£¬Êý¾ÝʹÓÃÍê±Ïºó£¬É¾³ýÁÙʱ±íµÄÊý¾Ý¡£
³öÏÖµÄÏÖÏ󣺵±OracleÖØÐÂÆô¶¯ºó£¬µÚÒ»Ò³²åÈëµÄ ......

oracle³õѧÕßÄãÇë½Ì - Oracle / »ù´¡ºÍ¹ÜÀí

--½¨Á¢Ò»¸ö°üÒÔ¶¨ÒåÒ»¸öÓαê
create or replace package PK_test 
as 
type cur_test is ref cursor;
end PK_test;
--½¨Á¢Ò»¸ö¹ý³Ì,ͨ¹ýÊäÈëJOBID£¬·µ»ØÒ»¸ö±í¼Ç¼£¨Óα꣩!
create or replace ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ