17,140
社区成员




-- 大概这样 ,没有环境
create table test (name varchar(30));
insert into test values('test1_20151121');
insert into test values('test2_20151123');
insert into test values('test3_20151124');
insert into test values('test4_20151124');
insert into test values('test5_20151125');
/
select * from test ;
select * from test where name like '%result%' || to_char(sysdate,'yyyymmdd');
drop table test ;