为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】:麒麟
【CPU】:
【问题描述】*:达梦执行动态SQL时,传递的参数会被解析为字段,我想要的结果是解析成字符串,以下是执行的SQL
DECLARE
QYK VARCHAR(50);
c1 CURSOR;
BEGIN
OPEN c1 FOR SELECT distinct owner from all_tables where owner like '%QYK_%';
LOOP
FETCH c1 INTO QYK;
EXIT WHEN c1%NOTFOUND;
execute immediate 'select X,Y,'||QYK||'as QYK from TB1';
END LOOP;
CLOSE c1;
END;
执行后会报一个错误,没有XXX这个字段
select X,Y, '''||QYK||'''as QYK 试试?
DECLARE
QYK VARCHAR(50);
c1 CURSOR;
BEGIN
OPEN c1 FOR SELECT distinct owner from all_tables where owner like '%QYK_%';
LOOP
FETCH c1 INTO QYK;
EXIT WHEN c1%NOTFOUND;
execute immediate 'select X,Y,'''||QYK||'''as QYK from TB1';
END LOOP;
CLOSE c1;
END;