RESTRICTING AND SORTING DATA
WHERE department_id = 90;
WHERE last_name = 'Whalen';
In the below example we are trying to compare the last name with CAPITAL format of WHALEN, but employees table stores ass the last names in mixed case, so no rows are returned for the below query:
SELECT last_name, job_id, department_id
WHERE last_name = 'WHALEN';>
Oracle DB stores date in an internal numeric format, representing the century, year, month, day, hours, minutes and seconds. The defalut date display is DD-MON-RR.