1.方法实现:
function getColValue(p_table varchar,p_column varchar) return varchar is
t_str varchar(50);
v_sql varchar2(1000);
begin
v_sql :='with base as (select '||p_column ||',rownum line from '||p_table ||' a)
select '||p_column ||'
from base t
where t.line = (select max(floor(DBMS_RANDOM.VALUE(1,(select count(*) from '||p_table ||')))) from dual)';
execute immediate v_sql into t_str;
return t_str;
end;
2.方法引用:
select getColValue('T_USER','USERID') from dual;