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

Oracle´æ´¢¹ý³Ì°üº¬Èý²¿·Ö

Oracle´æ´¢¹ý³Ì°üº¬Èý²¿·Ö£º¹ý³ÌÉùÃ÷£¬Ö´Ðйý³Ì²¿·Ö£¬´æ´¢¹ý³ÌÒì³£¡£
Oracle´æ´¢¹ý³Ì¿ÉÒÔÓÐÎÞ²ÎÊý´æ´¢¹ý³ÌºÍ´ø²ÎÊý´æ´¢¹ý³Ì¡£ 
Ò»¡¢Î޲γÌÐò¹ý³ÌÓï·¨
 
1 create or replace procedure NoParPro
2 as  ;
3 begin
4 ;
5 exception     //´æ´¢¹ý³ÌÒì³£
6     ;
7 end;

        ¶þ¡¢´ø²Î´æ´¢¹ý³ÌʵÀý
 1 create or replace procedure queryempname(sfindno emp.empno%type) as
 2        sName emp.ename%type;
 3        sjob emp.job%type;
 4 begin
 5        ....
 7 exception
          ....
14 end;
15 
    Èý¡¢ ´ø²ÎÊý´æ´¢¹ý³Ìº¬¸³Öµ·½Ê½
 1 create or replace procedure runbyparmeters  (isal in emp.sal%type,
                            sname out varchar,sjob in out varchar)
 2  as icount number;
 3  begin
 4       select count(*) into icount from emp where sal>isal and job=sjob;
 5       if icount=1 then
 6         ....
 9       else
10         ....
12       end if;
13  exception
14       when too_many_rows then
15       DBMS_OUT


Ïà¹ØÎĵµ£º

Oracle For Update ÐÐËø


ת£ºhttp://hi.baidu.com/mcj0127/blog/item/111a900777db06c87b89473c.html
SELECT FOR UPDATE Ïà¹ØµÄ֪ʶ
Ò»¸öÓʼþ·¢Ë͵ÄÓ¦Óûáÿ¹ýÒ»¶¨µÄʱ¼äƬȥÊý¾Ý¿âÖÐȡδ·¢µÄÓʼþÈ»ºó·¢ËÍÓʼþ£¬³É¹¦ºó½«Êý¾Ý¿âÖÐÓʼþ±êʶδ·¢¸ÄΪÒÑ·¢¡£
Õâ¸öÓ¦Óò¿ÊðÔÚwebsphereÉÏ£¬websphere²ÉÓÃÊÇ´¹Ö±¿Ë¡£¬ÓÐ4¸öserver,µ±4¸öserver¶¼¿ªÆôµÄ ......

oracle ÖØ½¨¿ØÖÆÎļþ

ORACLEµÄ¿ØÖÆÎļþÊÇÊý¾Ý¿âµÄ·Ç³£ÖØÒªµÄÎļþ£¬Ëü±£´æ×ÅÊý¾Ý¿âµÄÁ¬½ÓʵÀý(instance)ºÍdatabaseµÄÒ»¸öÇÅÁº£¬Ëü¶¨ÒåÁ˵±Ç°Êý¾Ý¿âÎïÀíÐÅÏ¢µÄ״̬¡£Òò´Ë¿ØÖÆÎļþ¶ÔÓÚÒ»¸öÊý¾Ý¿âÀ´ËµÊǷdz£ÖØÒªµÄ£¬ÔÚijЩʱºòÎÒÃÇÐèÒªÖØÐ´´½¨¿ØÖÆÎļþ£º
1¡£µ±¿ØÖÆÎļþ¶ªÊ§µÄʱºò£¬²¢ÇÒûÓÐ×î½üµÄÎļþCopy±¸·Ý£¨Ò»°ãÔÚ½¨¿âÍê³ÉºóµÄÉú³ÉÒ»¸ö´´½¨Con ......

OracleÓû§¡¢È¨ÏÞ¡¢½ÇÉ«¹ÜÀí

OracleÓû§¡¢È¨ÏÞ¡¢½ÇÉ«¹ÜÀí
Oracle ȨÏÞÉèÖÃ
Ò»¡¢È¨ÏÞ·ÖÀࣺ
ϵͳȨÏÞ£ºÏµÍ³¹æ¶¨Óû§Ê¹ÓÃÊý¾Ý¿âµÄȨÏÞ¡££¨ÏµÍ³È¨ÏÞÊǶÔÓû§¶øÑÔ)¡£
ʵÌåȨÏÞ£ºÄ³ÖÖȨÏÞÓû§¶ÔÆäËüÓû§µÄ±í»òÊÓͼµÄ´æÈ¡È¨ÏÞ¡££¨ÊÇÕë¶Ô±í»òÊÓͼ¶øÑԵģ©¡£
¶þ¡¢ÏµÍ³È¨ÏÞ¹ÜÀí£º
1¡¢ÏµÍ³È¨ÏÞ·ÖÀࣺ
DBA: ÓµÓÐÈ«²¿ÌØÈ¨£¬ÊÇϵͳ×î¸ßȨÏÞ£¬Ö»ÓÐDBA²Å¿ÉÒÔ´´ ......

oracleÔ¶³ÌÁ¬½Óµ¼Èëµ¼³öÊý¾Ý¿â

·½Ê½Ò».
Ö´ÐÐÒÔÏÂsqlÓï¾ä´´½¨database link
create database link test_link  --Á´½ÓÃû
  connect to   Óû§Ãû   identified by ÃÜÂë
  using '(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = Êý¾Ý¿â·þÎ ......

Oracle RACÐÔÄÜ Oracle sequence ÐÔÄܲâÊÔ

ÔÚOracle RAC»·¾³ÖУ¬ÏµÍ³ÐÔÄÜ»áÊܵ½Ó°Ï죬Ö÷Òª¼¯ÖÐÔÚBlockÔÚinstanceÖ®¼äµÄ´«Ê䣬¾¡¹Üoracle 10g ÖвÉÓÃÁËCache FusionÀ´¸ÄÉÆÒÔÇ°ÖØdiskÖжÁÈ¡Êý¾Ý¡£ÆäÖеÄÒ»¸ö²¿·Ö¾ÍÊǹØÓÚoracle sequenceµÄÐÔÄÜÎÊÌâ
ÏÂÃæÊǹØÓÚsequence µÄcacheºÍorder¶Ôrac ÐÔÄܵÄÓ°Ï죬´Ó²âÊÔÖп´µ½Ôö´ócacheºÍ²ÉÓÃnon-orderedµÄsequenceÐÔÄÜÊܵ½µÄÓ° ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ