Oracle Frequently Encountered Questions

• How do I get Year or Month etc From Date?
  Use the Extract Function

SELECT EXTRACT(MONTH FROM ORDER_DATE) ORDER_MONTH FROM ORDERS;

• Can I use aliases in where clause?
  The answer is No

SELECT EXTRACT(MONTH FROM ORDER_DATE) ORDER_MONTH FROM ORDERS WHERE ORDER_MONTH = 10;--don't do this

SELECT EXTRACT(MONTH FROM ORDER_DATE) ORDER_MONTH FROM ORDERS WHERE EXTRACT(MONTH FROM ORDER_DATE) = 10;--do like this

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!