>>>Previous>>>

Restricting and Sorting Data" covers the following topics.

WHERE Clause - Comparison Operators; Logical Operator; Using the Logical Operator, AND; Using the logical Operator, OR; Using the Logical Operator, NOT; Nesting Logical Operators; Other Comparison Keywords; Using the Keyword, LIKE; Using the Keywords, BETWEEN...AND; Using the Keyword, IN; Using the Keyword, IS NULL ORDER BY Clause - Using the ORDER BY Clause.

Expressions in a SELECT statement:

Arithmetic operations can be performed using SELECT statement as shown below.

SQL> SELECT 10+5 FROM DUAL;
10+5
----------
15

SQL> SELECT 10-5 FROM DUAL;
10-5
----------
5

SQL> SELECT 10*5 FROM DUAL;

10*5
----------
50

SQL> SELECT 10/5 FROM DUAL;

10/5
----------
2

>>>Next>>>