是在存储过程里面?
动态sqlv_str varchar2(200);
begin
v_str:='select column1 ,'||a||' as columnx from t';
execute immediate v_str into col1,cola;
end;
/
动态sqlv_str varchar2(200);
begin
v_str:='select column1 ,'||a||' as columnx from t';
execute immediate v_str into col1,cola;
end;
/
select column1,column2 into a,B from t WHERE ID=111;
不过这条语句只能返回一条记录,返回多条记录要使用到游标。