Date in Where Clause Oracle Tutorial Example

How to Use Date in Where Clause Oracle Database Tutorial Example

Run Query Editor then copy & paste the below code to use date in where clause in Oracle Database Server Tutorial Example

   -- CONNECT AS Any User or HR

   SELECT    LAST_NAME, SALARY, HIRE_DATE
   FROM      EMPLOYEES
   WHERE     HIRE_DATE > '10-JAN-2000' ;
   -- is comment in Oracle
   -- in fact it is comment in MSSQL and MySQL as well

How to Use Date in Where Clause Oracle Database Tutorial Example - Result in Query Editor Client Tools

No comments:

Post a Comment

leave your comments here..