ÇóÖúoracleÖÐSQL¶¯Ì¬Ö´ÐеÄÎÊÌ⣬¼±£¡£¡

±íÃûÊǶ¯Ì¬´«½øÈ¥µÄ£¬ÇëÎÊ¿ÉÒÔ½¨ÕâÑùµÄfunctionÂð£¿
function²ÎÊýΪ±íÃû£¬IDºÍ×Ö¶ÎÃû£»
ÀïÃæÀûÓÃÕâ¸ö±íÃûÆ´Ò»¸öSQLÓï¾äÈ¡³ö¸Ã×ֶεÄÖµÓÃÓαêÖ´Ðн«½á¹ûfetch³öÀ´·µ»Ø¡£
functionÖеÄSQL´®ÊDz»ÊDz»ÄÜÆ´±íÃûºÍ×ֶΣ¬Ö»ÄÜÆ´×ֶεÄÖµ£¿

´ó¼ÒÄܲ»ÄÜ°ï°ïÎÒ£¬Ó¦¸ÃÔõôŪ£¬Íò·Ö¸Ðл£¡£¡£¡

---

SQL code:
create or replace function fun(v_table in varchar2,
id in number,
v_col in varchar2)
return varchar2
is
v varchar2(2000);

begin

execute immediate 'select '||v_col||' from '||v_table||' where id = '||id into v;
return v;
end fun;
/

---

Ó¦¸ÃûÎÊÌâµÄ°É£¬
ÄãÊǵĶ¯Ì¬SQL£¬ÊDz»ÊÇÖ¸ ref cursor

---

ÒýÓÃ

SQL codecreateorreplacefunction fun(v_tableinvarchar2,
                              idinnumber,
                              v_colinvarchar2)returnvarchar2is
  vvarchar2(2000);beginexecute immediate'select'||v_col||' from'||v_table||' where id ='||idinto v;return v;end fun;/

±àÒëµÄʱºòûÎÊÌ⣬µ«ÊÇÖ´ÐеÄʱºò˵ÕâÒ»ÐÐ
execute immediate 'select '||v_col||' from