Oracle技巧

查整张表
insert into T0107_FilmImg
select filmNo,filmno,filmname,'jpg',filmname,'beizhu' from T0107_Film

insert into T0107_FilmImg
select filmNo+30,filmno,filmname,'jpg','http://'||filmname,'beizhu' from T0107_Film

时间查询
select filmName,filmNo from T0107_Film where  to_date(filmbegdate,'yyyy-MM-dd') > sysdate - 30

select * from T0200_Feature where to_date(featuredate,'yyyy-MM-dd') >= (trunc(sysdate))