Duration: 24:15 min
Summary: The SELECT statement have many clauses. In order to filer the rows returned by the Oracle database in a SELECT statement we employ the WHERE classer with one or more filtering conditions that specify how we want to filter the data. To sort the data we use the ORDER BY clause. This video explain how the WHERE and the ORDER BY clauses of the SELECT statement work in the PL/SQL language and provide many examples of the operators that can be used in the WHERE clause, include the equal (=), BETWEEN, IN() and LIKE. The video also show some examples of the operators AND, OR and NOT to control how more than one filter can be used to filter the rows in a SELECT statement. Finally, the ORDER BY clause is explained with the ASC and DESC column modifiers.