--行转列的函数--
CREATE OR REPLACE FUNCTION Calvin(
col IN VARCHAR2,dw
IN VARCHAR2)
RETURN VARCHAR2
IS
retval varchar2(
32);
Sel_sql varchar2(
2000);
---//SQL语句声明
BEGIN
Sel_sql:='select '||col
||' from TB5001 where dwdm='''|| dw
||'''';
execute immediate Sel_sql
into retval ;
--执行oracle 方法
RETURN lower(retval);
END;
/
select calvin(zdm,
'ftgm')
as key,wbklx
from JGTB5001;
转载于:https://www.cnblogs.com/siyunianhua/p/4122525.html
