How to display those employee who joined in the company in the month of Dec?

Oracle Apps Interview QuestionsCategory: SQLHow to display those employee who joined in the company in the month of Dec?
Questions Master asked 10 years ago

How to display those employee who joined in the company in the month of Dec?

1 Answers
Shailender Thallam Staff answered 10 years ago

SELECT ename,hiredate FROM emp WHERE TO_CHAR(hiredate,’MON’)=’DEC’;