Oracle SQL & PL/SQL

This clause is used to provide comparison of data, which restricts the rows from a table. A WHERE clause contains a condition that must be met and should directly follow the from clause. Comparison to date type data is not case sensitive. Character values are case sensate and Date values are format Sensitive (DD-MON-YY). The WHERE clause can compares..       Ø   Values in columns         Ø   Literal Values         Ø   Arithmetic Expressions         Ø   Function Examples :- Display all those employees, who are working as CLERK. Ans : Select * from emp where job = ‘CLERK’; Display all those employees, who are working in deptno 20. Ans : Select * from emp where deptno=20; Display all those employees, who have been hired on 3 rd -dec-81. Ans : Select * from emp where hiredate=’3 rd -dec-81’; Display empno,ename,job,sal,deptno for all those empl...