17,089
社区成员
发帖
与我相关
我的任务
分享
-- 大概这样 ,没有环境
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 ;