When performing search operations, you can use the following clauses:
This is the most commonly used clause in searched operations. The WHERE clause allows you to specify the conditions that determine which data is to be retrieved and optionally updated or deleted. The WHERE clause is also used in cursor operations to search for data.
This clause may be used in searched operations. The ORDER BY clause allows you to specify the order in which values are returned from tables.
Copyright © 2014 CA.
All rights reserved.
|
|