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

¹ØÓÚoracle ÓαêµÄÎÊÌâ[ÓеãºÃÆæ]

ÎÒÉùÃ÷ÁËÒ»¸öÓα꣬´ÓÊý¾Ý¿âÀïÃæ²éÁË10000Ìõ¼Ç¼³öÀ´:
SQL code:

CURSOR Cur_Push IS
SELECT id,isOk
from mytable t;



È»ºó±éÀúÿÌõ¼Ç¼£¬¸Ä±äÀïÃæµÄÖµ£º

SQL code:

OPEN Cur_Push;
LOOP

FETCH Cur_Push
INTO v_id,v_Ok

EXIT WHEN Cur_Push%NOTFOUND;

IF(v_Ok='N')THEN
UPDATE mytable
SET isOk ='Y'
WHERE ID =v_id;
END IF;



Èç¹ûÔÚËüÕýÔËÐеÄʱºòÎÒ²»¶Ï°ÑËüÒѾ­¸Ä¹ýÈ¥µÄÖµÓָĻØÀ´£¬Ëü»á²»»áÒ»Ö±¶¼½áÊø²»Á˰¡£¿
²»»á£¬¶ÁÒ»Ö¶¥¡£
´ò¿ªÓαêʱ£¬½á¹û¼¯ÒѾ­È·¶¨¡£

¶ÁÒ»ÖÂÐÔ

ÒýÓÃ
¶ÁÒ»ÖÂÐÔ


Ò²¾ÍÊÇ˵ÔÚ´ò¿ªÓαêʱËüÀïÃæËùÓõ½µÄÊý¾ÝÒѾ­´æµ½ÄÚ´æÀïÈ¥ÁË?  Èç¹û¼Ç¼ËùÕ¼µÄ¿Õ¼äºÜ´óÄØ£¿ oracle »á²»»á½øÐиöʲôÓÅ»¯´¦Àíµ½ÄIJ¿·ÖÔÙÈ¥Êý¾Ý¿â¶Á?

ÄãÊÔÊÔ  insert into test select * from test

¾ÍÖªµÀÁË Ö»»á²åÈëÒ»´Î


ÒýÓÃ
ÒýÓà 3 Â¥ yjl49 µÄ»Ø¸´:
ÒýÓà 2 Â¥ suiziguo µÄ»Ø¸´:
¶ÁÒ»ÖÂÐÔ


Ò²¾ÍÊÇ˵ÔÚ´ò¿ªÓαêʱËüÀïÃæËùÓõ½µÄÊý¾ÝÒѾ­´æµ½ÄÚ´æÀïÈ¥ÁË?  Èç¹û¼Ç¼ËùÕ¼µÄ¿Õ¼äºÜ´óÄØ£¿ oracle »á²»»á½øÐиöʲôÓÅ»¯´¦Àíµ½ÄIJ¿·ÖÔÙÈ¥Êý¾Ý¿â¶Á?



Ïà¹ØÎÊ´ð£º

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

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

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

OracleÀëÏß·ÃÎÊ---ÇóÖú - Oracle / »ù´¡ºÍ¹ÜÀí

´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄԭʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
    ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......

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

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

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

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

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

ÒýÓÃ
oracle ......

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

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

1. Oracle sid ÕýÈ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ