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

OracleתÒå·ûºÅ

CREATE OR REPLACE PROCEDURE proc_ct_11(
  quhao in varchar
)
IS
  CURSOR ct_filter
  IS
      SELECT        br_number, br_company
              from ct_lsb
      FOR UPDATE OF br_count;

  v_br_number    VARCHAR2 (128);
  v_count        PLS_INTEGER;
  v_error        VARCHAR2 (150);
  v_br_company  VARCHAR2 (150);
  sub_br_number  VARCHAR2 (128);
  v_exit   int;
BEGIN
  OPEN ct_filter;
  LOOP                                         
    FETCH ct_filter INTO v_br_number, v_br_company;
EXIT WHEN ct_filter%NOTFOUND;
IF instr(v_br_number,'/')=0
  THEN
v_br_number:=SUBSTR (v_br_number, 6,7);
    EXECUTE IMMEDIATE 'SELECT COUNT (*) INTO v_count from br_'||quhao ||' WHERE instr(br_number, '||v_br_number||')>0 OR br_company ='|| v_br_company;
     
¡­¡­

×îºóµÄ EXECUTE IMMEDIATE ÄǸösqlÓï¾ä ÓÉÓÚv_br_number£¬v_br_companyÊÇvarcharÐÍ ÒªÖ´ÐеÄsqlÒª¼Óµ¥ÒýºÅ ÇëÎÊÒªÔõôд²Å¶Ô£¿{{----}


Ïà¹ØÎÊ´ð£º

.netµ÷ÓÃOracle´æ´¢¹ý³ÌµÄÖØÔØÎÊÌâ

Oracle´æ´¢¹ý³ÌÈçÏÂ,ÓÃÓαêÊä³ö½á¹û:
procedure proc_xcxf_detail(v_sbh varchar2,
                          v_szpq varchar2,
&nbs ......

oracle´æÈ¡Ð¡ÓÚ1µÄСÊý£¬ÎªÊ²Ã´ÊÇûÓÐÁã

ÔÚ´æÈ¡Ð¡Êý£¬ÀýÈç0.5µÄʱºò£¬ÎªÊ²Ã´´æÈ¡µ½Êý¾Ý¿âÖбä³É  .5  µÄÐÎʽ£¿
½â¾ö·½°¸ÒѾ­ÓÐÁË£¬ÎÒÖ÷Òª¹ØÐĵÄÊÇoracleΪʲô»áÕâô´æ´¢£¿

ÄãËù¿´µ½µÄÊÇ´æ´¢µÄÊý¾ÝµÄÏÔʾ·½Ê½£¬Ö»ÊÇÒ»¸ö±íÏ󣬲¢²»Ó°ÏìÊý¾ÝÔÚÊ ......

Çë½ÌDRIVER={Microsoft ODBC for Oracle} Á¬½ÓÎÊÌ⣡

ÊÇÕâÑùµÄÎÒ×°ÁËһ̨2003µÄÐéÄâ»ú£¡

ÐéÄâ»úIP£º192.168.1.108
±¾»úIP£º192.168.1.100

ÎÒÔÚÐéÄâ»úÉÏ×°ÁËoracle 10G ,ÏÖÔÚÏë±àд¸ö³ÌÐò¶ÁÈ¡oracleÊý¾Ý¿âÀïµÄ¼Ç¼£¬

ÎÒÔÚ±¾»ú×°Á˸öoracle XE Cl ......

oracle procedure ʵ¼Ê¿ª·¢Óöµ½µÄÎÊÌâ

ÓÐÁ½Õűí
1.µÚÒ»ÕÅ,ÊýÁ¿°ÙÍò¼¶
id  number Ö÷¼ü
name varchar(50)
2.µÚ¶þÕÅ,ÊýÁ¿1Íò¼¶
id number Ö÷¼ü
deletename varchar(50)


ÏÖÔÚµÄÎÊÌâÊÇҪдһ¸ö´æ´¢¹ý³Ì,ɾ³ýµÚÒ»ÕűíÖеÄn ......

ORACLE È¡×î´óÖµ

±í×Ö¶Î

ID      NAME    TIME    AMOUNT

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