--获得价格区间--
CREATE OR REPLACE function WANFO. fn_GetPriceArea ( v_dj
number )
return varchar2
is
v_jgqj varchar2(
50);
SQL_GETPRICEAREA varchar2(
2000);
begin
SQL_GETPRICEAREA:='SELECT flag FROM JGQJB WHERE ZXJE <= ''' ||v_dj
||''' AND ZDJE > '''||v_dj
|| ''' ';
execute immediate SQL_GETPRICEAREA
into v_jgqj;
--执行oracle 方法
if v_jgqj
is null or v_jgqj
='' then ---判读返回值是否为空
begin
v_jgqj :=0;
end;
end if;
return v_jgqj;
exception
when others
then dbms_output.put_line(
'error');
return -1 ;
end fn_GetPriceArea ;
/
转载于:https://www.cnblogs.com/siyunianhua/p/5102211.html
相关资源：JAVA上百实例源码以及开源项目
