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

ORACLE ´æ´¢¹ý³Ìͬ²½µÄÎÊÌâ

ÎÒÔÚÒ»¸ö´æ´¢¹ý³ÌÒªÔõô¼ÓËø£¬Ã¿´ÎÖ»ÄÜÓÉÒ»¸öÓû§ÆäËûÓû§Ö´ÐУ¬È»ºóÆäËûµÄÓû§ÒªµÈ´ý£¿
¿ÉÒÔÕâÑù:
½¨Á¢¹ý³ÌA ×¼±¸µ÷Óùý³ÌB
create procedure A is
begin
update table set column = ....;
exex B;
commit;
end;
/
ÕâÑù¾Í¿ÉÒÔÁË



ÒýÓÃ

¿ÉÒÔÕâÑù:
½¨Á¢¹ý³ÌA ×¼±¸µ÷Óùý³ÌB
create procedure A is
begin
update table set column = ....;
exex B;
commit;
end;
/
ÕâÑù¾Í¿ÉÒÔÁË

ÉÏÃæÐ´µÄÖ»ÊÇα´úÂë Ö´ÐÐupdateʱ»á¼ÓËø µ±ÄãÔÚÖ´ÐÐAʱ(AÖÐÖ´ÐÐB)±ðÈËÖ»Äܵȴý 
Ö±µ½Äãµ÷ÓÃB½áÊøºócommit

SQL code:
CREATE PROCEDURE proc_A IS
BEGIN
--ÊÖ¹¤¼ÓËø(Ö»ÓÐÒ»¸öÓû§Äܳɹ¦£¬ÆäËüÓû§±ØÐëµÈ´ý)
SELECT * from temp FOR UPDATE; --temp±íÓÃÓÚ¼ÓËø
--µ÷ÓÃproc_B
proc_B; --×¢ÒâÒª´®ÐеĴ洢¹ý³ÌBÖв»ÄÜcommit,Èç¹û±ØÐëÌá½»¿ÉʹÓÃ×ÔÖÎÊÂÎñ
--Ìá½»²¢ÊͷűíËø
COMMIT;
--ÆäËüÓû§¿ÉÒÔµ÷ÓÃproc_B
END;


ÒýÓÃ

SQL code
CREATE PROCEDURE proc_A IS
BEGIN
--ÊÖ¹¤¼ÓËø(Ö»ÓÐÒ»¸öÓû§Äܳɹ¦£¬ÆäËüÓû§±ØÐëµÈ´ý)
SELECT * from temp FOR UPDATE; --temp±íÓÃÓÚ¼ÓËø
--µ÷ÓÃproc_B
proc_B; --×¢ÒâÒª´®ÐеĴ洢¹ý³ÌBÖв»ÄÜcommit,Èç¹û±ØÐëÌá½»¿ÉʹÓÃ×ÔÖÎÊÂÎñ
--Ìá½»²¢ÊͷűíËø
COMMIT;
¡­¡­

ΪʲôҪÕâÑù£¿
ÄÜ˵˵ԭÒò²»£¿

CREATE


Ïà¹ØÎÊ´ð£º

oracle 10g webµÇ½EMµÄÎÊÌ⣿ - Oracle / »ù´¡ºÍ¹ÜÀí

°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿

1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......

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

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

ÒýÓÃ
oracle ......

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

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

oracleµÄ°²×°ºÍʹÓúÃÄѰ¡ - Java / Java EE

oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿Ô­À´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......

oracle֪ʶ - Oracle / »ù´¡ºÍ¹ÜÀí

ÔÚOracle Êý¾Ý¿âÖÐÔõô²éǰÈýÌõ¼Ç¼½µÐò£»
select * from
  (select * from table order by col_name desc)
where rownum<=3;

select * from
(
select s.*,rownum rn 
from t3 s
)
where ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ