摘要： create or replace function Getweekbydate(sdate in date) return number is Result number;begin select to_char(decode(sign((to_date(to_char(sdate, 'yyyym 阅读全文

摘要： --创建测试数据 create table bk_tesk(id varchar2(10),s varchar2(20)); insert into bk_tesk values ('A','1,2,3');insert into bk_tesk values ('B','4,5,6');inser 阅读全文