Home >> Oracle >> EXISTS in Oracle

EXISTS in Oracle

The EXITS is similar to IN.
The EXITS is faster than IN.
The EXITS used to check whether the result of a correlated nested query is empty or not.
The EXITS will return TRUE if at least one tuple is the result of nested query.

Example

SELECT * FROM suppliers s WHERE EXITS (SELECT o.name FROM orders o WHERE s.sid=o.sid);

Post Your Comment

Next Questions
NOT EXITS
ANY
ALL
MAX
MIN
AVG
COUNT
SUM
What is key
What is Super Key
What is Candidate Key
What is Primary Key
What is Unique Key
What is Foreign Key
Function
Procedure
Cursor
Trigger
Before Trigger
After Trigger
DROP Trigger
DISABLE Trigger
ENABLE Trigger
Aggregate Functions
APPROX_COUNT_DISTINCT() Aggregate function

Copyright ©2022 coderraj.com. All Rights Reserved.