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Òª¼Óµ¥ÒýºÅ ÇëÎÊÒªÔõôд²Å¶Ô£¿{{----}
Ïà¹ØÎÊ´ð£º
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......
´úÂë
select * from ct_lsb where br_number like '0746 8[1-3]%'
ÇëÎÊ ÎªÊ²Ã´Õâ¸ö²é²»³öÊý¾Ý£¿
select * from ct_lsb where br_number like '0746 83%'Õâ¸ö²éµÄ³ö¶î£¡
select ......
ÔÚ´æÈ¡Ð¡Êý£¬ÀýÈç0.5µÄʱºò£¬ÎªÊ²Ã´´æÈ¡µ½Êý¾Ý¿âÖбä³É .5 µÄÐÎʽ£¿
½â¾ö·½°¸ÒѾÓÐÁË£¬ÎÒÖ÷Òª¹ØÐĵÄÊÇoracleΪʲô»áÕâô´æ´¢£¿
ÄãËù¿´µ½µÄÊÇ´æ´¢µÄÊý¾ÝµÄÏÔʾ·½Ê½£¬Ö»ÊÇÒ»¸ö±íÏ󣬲¢²»Ó°ÏìÊý¾ÝÔÚÊ ......
ÊÇÕâÑùµÄÎÒ×°ÁËһ̨2003µÄÐéÄâ»ú£¡
ÐéÄâ»úIP£º192.168.1.108
±¾»úIP£º192.168.1.100
ÎÒÔÚÐéÄâ»úÉÏ×°ÁËoracle 10G ,ÏÖÔÚÏë±àд¸ö³ÌÐò¶ÁÈ¡oracleÊý¾Ý¿âÀïµÄ¼Ç¼£¬
ÎÒÔÚ±¾»ú×°Á˸öoracle XE Cl ......
ÂÒÂë²úÉúÊÇÓÉÓÚ¼¸¸ö×Ö·û¼¯Ö®¼äת»»²»Æ¥ÅäÔì³É£¬·ÖÒÔϼ¸ÖÖÇé¿ö£º£¨×¢£º×Ö·û¼¯Ö®¼äÈç¹û²»´æÔÚ×Ó¼¯¡¢³¬¼¯¶ÔÓ¦¹ØÏµÊ±µÄÇé¿ö²»Ó迼ÂÇ£¬ÒòΪÕâÖÖÇé¿öÏÂ×Ö·û¼¯Ö®¼äת»»±Ø²úÉúÂÒÂ룩
1£©·þÎñÆ÷¶ËÊý¾Ý¿ ......