4 Search Conditions

A search condition specifies criteria for choosing rows to select, update, or delete. Search conditions are parameters that can exist in clauses and expressions of any DML statements, such as INSERT...SELECT, UPDATE and CREATE VIEW and some DDL statements, such as CREATE VIEW.