 |
Home
Oracle
SQL
PL/SQL
MySQL
MongoDB
PostgreSQL
SQL Server
SQLite
Cassandra
DBMS
Python
Java
Aptitude
Interview Q
ORACLE EXISTSIn Oracle, exists clause is used with select, insert, update, delete statements. It is used to combine the queries and creating subquery. SyntaxParameterssubquery: It is a select statement which returns at least one record set. Table 1:
Table 1:
Example 1Query: select name from table1 where exists (select *from table2 where table1.id=table2.id) 
Example 2Query: select id, salary from table2 where exists (select *from table1 where table2.id=table1.id) 
Example 3Query: select * from table1 where not exists (select *from table2 where table1.id=table2.id) 
Next TopicIN
|
For Videos Join Our Youtube Channel: Join Now
Feedback
- Send your Feedback to [email protected]
Help Others, Please Share
Like/Subscribe us for latest updates or newsletter 
