Logo 
Search:

Oracle Articles

Submit Article
Home » Articles » Oracle » OperatorsRSS Feeds

EXISTS OPERATOR

Posted By: Evie Brown     Category: Oracle     Views: 2436

This article explains about EXISTS OPERATOR with example.

Customer - orders - salespeople database

EXISTS OPERATOR 

- takes a sub-query as a argument and evaluates to TRUE if there is output OR FALSE if it does not produces output.

select data from Customers table,if and only if there is a customer located in ahmd city.

SELECT * FROM Customers WHERE EXISTS (SELECT * FROM Customers WHERE city='chennai');

  
Share: 


Didn't find what you were looking for? Find more on EXISTS OPERATOR Or get search suggestion and latest updates.

Evie Brown
Evie Brown author of EXISTS OPERATOR is from London, United Kingdom.
 
View All Articles

 
Please enter your Comment

  • Comment should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].

 
No Comment Found, Be the First to post comment!