如:
cmd:='SELECT * FROM b_ztry WHERE zhbz is null';
--获取记录
if sfz<>'' then
n:=1;
declare CURSOR c1 IS cmd;
BEGIN
END;
这样就会出错,因为我想根据我的查询条件自动生成SQL语句,这样就可以使用索引了,
NOW WHAT SHALL I DO,HELP ME !!!!
cmd:='SELECT * FROM b_ztry WHERE zhbz is null';
--获取记录
if sfz<>'' then
n:=1;
declare CURSOR c1 IS cmd;
BEGIN
END;
这样就会出错,因为我想根据我的查询条件自动生成SQL语句,这样就可以使用索引了,
NOW WHAT SHALL I DO,HELP ME !!!!
带有参数的游标DECLARE
CURSOR CUR_TEST (theID VARCHAR2) IS SELECT * FROM TEST WHERE ID=theID;
BEGIN
FOR R IN CUR_TEST('10') LOOP
DBMS_OUTPUT.PUT_LINE(CUR_TEST.NAME);
END LOOP;
END;
/