In Oracle, EXISTS operator allows you to check existence of any record in a subquery. The EXISTS operator can be used in a SELECT, INSERT, UPDATE, or DELETE statement.
To check existence of any record in a subquery, use the following syntax:
Parameters:
tablename: The table name from which you want to perform EXISTS
operator.
subquery: Usually a SELECT statement starts with SELECT * or column name. Oracle ignores the SELECT list from subquery.
EXISTS
operator is uses the Oracle EXISTS
operator:
Note:
In the above example, the EXISTS
operator will return all records from the "tblbankdemataccountcharges" table where there is record in the tblbankheadquartersandaddress table with the matching "bankId".