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要加单引号 请问要怎么写才对?{{----}
相关问答:
环境:1.win2003server+oracle9i
2.oracle9i字符集为AMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer版本 1.5.5
现象描述: 1.在sql developer 中查询oracle中的某个表,中文全部显示为乱码。
......
<?php
getenv("ORACLE_HOME");
$conn=ocilogon("test","test","test_db");
if($conn)
echo success;
&nb ......
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 ......
表字段
ID NAME TIME AMOUNT
14502 1111 0201 1
14502 1111 0201 5
14 ......