The Oracle OR condition is used to test multiple conditions where records are returned when any one of the conditions are TRUE. It can be used in a SELECT, INSERT, UPDATE, or DELETE statement. In other hand, Oracle OR operator is filter record if any of the conditions separated by OR is TRUE.
To filter a record if any of the conditions separated by
OR is TRUE, use the following syntax:
tablename: The table name from which you want to fetch the records.
condition: To specifies multiple conditions, either of the condition must be true to select records.
In the above example, we are showing how to use the
OR operator to filter records based on any of the conditions separated by
OR is TRUE