TO_CHAR(hire_date, 'dd month yyyy') AS hiredate1, TO_CHAR(hire_date, 'fmdd yyyy') AS hiredate2 -- remove 0 in days ...
Basically, SQL is used to perform basic operations of creating a database, storing data in the database, updating data in the database, retrieving the stored data of database, etc, whereas PL/SQL is a ...