- create or replace function fun_get_reversion_remark(bms_accept_id in varchar2) return varchar2
- ----根据定单id获取预约备注信息
- is
- Result varchar2(512);
- v_yyyymm varchar2(20);
- v_sql varchar2(512);
- begin
- v_yyyymm:=Substr(bms_accept_id, 0, 6);
- v_sql:='select bms_accept_detail From bms_accept_form_'||v_yyyymm||' t where sn=65 and t.bms_accept_id='''||bms_accept_id||'''';
- execute immediate v_sql into Result;
- return(Result);
- exception
- WHEN OTHERS THEN
- Result:=null;
- return Result;
- end fun_get_reversion_remark;
oracle 动态sql select into
最新推荐文章于 2023-05-31 15:57:34 发布