查询出EMP表中1982年及以后入职的员工信息()(注:字段hiredate为入职日期,数据类型为DATE型)
A:select * from emp where hiredate>='19820101';
B:select * from emp where hiredate>=to_char('19820101','YYYYMMDD');
C:select * from emp where to_date(hiredate,'YYYYMMDD')>='19820101';
D:select * from emp where to_char(hiredate,'YYYYMMDD')>='19820101';
出自:Oracle认证