摘要:
import java.util.Date; import java.text.SimpleDateFormat; Date now = new Date(); def portcodes = new StringBuffer('')for(portcode in params.fsetcode){ 阅读全文
摘要:
select to_char(wm_concat(ssss)) from (select replace(C_CELL_CONTENT ,'=$','') ssss ,rownum ss from ( select distinct C_CELL_CONTENT,1 sss from T_F_RC_ 阅读全文
摘要:
select replace ('111222333444','222','888') from dual;with tmp as(select 'aabb/123\:cde工人' s from dual union allselect 'c*o"中国人刀k<j>aa|' from dual)sel 阅读全文
摘要:
CREATE OR REPLACE Function getBdateT( D_Build date, Q_Date date) return Date as D_Return Date; /*返回的日期*/ Q_Year int := 1;/*查询日期的年份*/ Q_Quartar int := 阅读全文
摘要:
select * from t_s_da_sec_var r start with c_da_code='FZ_FZ' connect by nocycle prior r.c_da_code_p=r.c_da_code ;select * from t_s_da_sec_var r start w 阅读全文