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))
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))
