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

posted on 2008-01-25 12:21  online  阅读(155)  评论(0编辑  收藏  举报

导航