create or replace function get_sjbb(tyears varchar2,tnonth varchar2)return varchar2 as v_sql1 varchar2(4000); -- 返回字符串，你這里符合條件的是SQL語句beginSELECT COUNT(DECODE(TO_CHAR(RECIEVE_DATE, 'DD'), '01', 0)) as "1", COUNT(DECODE(TO_CHAR(RECIEVE_DATE, 'DD'), '02', 0)) as "2" into v_sql1FROM V_SJBB where TO_CHAR(RECIEVE_DATE,'YYYY') = tyears AND TO_CHAR(RECIEVE_DATE,'MM') = tnonth;return v_sql1;end;
1 回答
郎朗坤
TA貢獻1921條經(jīng)驗 獲得超9個贊
UPLOAD.OrderBy(x => x.SER_NO).Where((x, index) => index <= 1).Select((x, index) => new { x, index }).OrderByDescending(x => x.index);
- 1 回答
- 0 關(guān)注
- 91 瀏覽
添加回答
舉報
0/150
提交
取消