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要加单引号 请问要怎么写才对？{{----}
相关问答：
<?php
getenv("ORACLE_HOME");
$conn=ocilogon("test","test","test_db");
if($conn)
echo success;
&nb ......
代码
select * from ct_lsb where br_number like '0746 8[1-3]%'
请问 为什么这个查不出数据？
select * from ct_lsb where br_number like '0746 83%'这个查的出额！
select ......
Oracle存储过程如下,用游标输出结果:
procedure proc_xcxf_detail(v_sbh varchar2,
v_szpq varchar2,
&nbs ......
create or replace function GetWorkBeginTime()
return date is
myDate date;
begin
myDate := trunc(sysdate-1)+8/24;
return myDate;
end;
......
有两张表
1.第一张,数量百万级
id number 主键
name varchar(50)
2.第二张,数量1万级
id number 主键
deletename varchar(50)
现在的问题是要写一个存储过程,删除第一张表中的n ......
