是在存储过程里面？
动态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;
不过这条语句只能返回一条记录，返回多条记录要使用到游标。