查询出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'

时间:2022-09-12 08:11:49 所属题库:Oracle认证综合练习题库

相似题目