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要加单引号 请问要怎么写才对?{{----}
相关问答:
我安装一台redhat linux5+oracle 10g的服务器,笔记本(XP系统)安装了oracle 10g客户端,结果老是出12560的错误,请高手指点一二,
-A RH-Firewall-1-INPUT -m state –state NEW -m tcp -p tcp –dpor ......
<?php
getenv("ORACLE_HOME");
$conn=ocilogon("test","test","test_db");
if($conn)
echo success;
&nb ......
Oracle存储过程如下,用游标输出结果:
procedure proc_xcxf_detail(v_sbh varchar2,
v_szpq varchar2,
&nbs ......
ORACLE从9201升级到9208之后
环境变量中ORACLE_HOME没有设置 手工添加后
系统服务里所有ORACLE服务都起不来
命令行里输入 EXP或者LSNRCTL报提示无法定位程序输入点 lxhlcmod 于动态链接库 oranls9.dll上
......
是这样的我装了一台2003的虚拟机!
虚拟机IP:192.168.1.108
本机IP:192.168.1.100
我在虚拟机上装了oracle 10G ,现在想编写个程序读取oracle数据库里的记录,
我在本机装了个oracle XE Cl ......