Oracle EXISTS Operator

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.

Oracle EXISTS OPERATOR Syntax

To check existence of any record in a subquery, use the following syntax:

Syntax

SELECT col1, col2,....
FROM tablename
WHERE EXISTS (SELECT col1 FROM tablename WHERE condition);

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.

Oracle EXISTS OPERATOR example with SELECT statement

The following Oracle, EXISTS operator is uses the Oracle EXISTS operator:

Example

SELECT A.accountName 
FROM tblbankdemataccountcharges A 
WHERE EXISTS (SELECT B.banks FROM tblbankheadquartersandaddress B WHERE A.bankId = B.pk);

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".

« Previous