Oracle数据库操作常用语句

1.查询时间范围方法：

select * from test where to_char(date,'YYYYMMDD') >= '20140101'

2.查询数据库字段截取查询

select substr (iid,0,4) as name from t_test  group by substr (iid,0,4);