The Oracle WHERE clause is used to filter rows based on a particular condition. The WHERE clause is used with SELECT, INSERT, UPDATE and DELETE statements. Oracle allows you to use operator with Where clause.
To fetch the data based on specific condition, use the following syntax:
Parameters:
conditions: To specify the condition that must be fulfilled for records to be selected.
Note:
In the above example, we have fetched record from "tblCustomerLoan" table with cellNo "2888888980".
Note:
In the above example, we have fetch records from "tblCustomerLoan" table with cellNo "2888888980" AND aadharNo equal to "123456789012".
Note:
In the above example, we have fetch records from "tblCustomerLoan" table with cellNo "2888888980" OR aadharNo equal to "123456789012".
Note:
In the above example, we have fetch records from "tblCustomerLoan" table with cellNo "2888888980" OR aadharNo equal to "123456789012".
Some more useful operators that you can use with WHERE clause to form a complex conditions such as:
The WHERE clause is used with SELECT, INSERT, UPDATE and DELETE statements as well.