--行转列的函数--CREATE OR REPLACE FUNCTION Calvin(col IN VARCHAR2,dw IN VARCHAR2)RETURN VARCHAR2IS   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;