Where « Select Query « Oracle PL / SQL

  1. Oracle PL / SQL
  2. Select Query
  3. Where




1.Query a varchar2 type column in where statement
2.The TO_DATE function in where clause
3.WHERE clause with a GROUP BY clause
4.A list of all Employees whose salary is more than $5000
5.Use an analytical function in a WHERE clause
6.Using the WHERE, GROUP BY, and HAVING Clauses Together
7.Use ROWNUM in where clause
8.Where clause converts text with date value format to date value
9.Use Trunc in where clause





10.Combining WHERE Conditions
11.List all employees who are younger than Jane
12.List all employees with salary between 1300 and 1600