使用动态SQL的例子:
Function GetValue (tableName in varchar2, fieldName in varchar2, fid in number)
return varchar2 is
v_Value varchar2(1000) := '';
sqlstr varchar2(1000)
begin
sqlstr :='select '||fieldName||' from '||tableName||' where MI_PRINX ='|| to_char(fid);
execute immediate sqlstr into v_Value;
return v_Value;
end;
/