Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 spatial¿Õ¼äº¯Êý³ö´í - Oracle / ¸ß¼¶¼¼Êõ

ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏÂ
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......

sqlÓÅ»¯ - Oracle / »ù´¡ºÍ¹ÜÀí

select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' 
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......

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

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

ÇóÒ»sqlÓï¾ä - Oracle / ¿ª·¢

Á½¸ö±í
Çë¿´ "Persons" ±í£º
name banji shunxu
yiyang 01 1
yiyang 02 1
lili 01 2
  
½ÓÏÂÀ´Çë¿´ "xueke" ±í£º
name kemu shunxu
yiy ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ