The EXISTS condition in Oracle SQL / PLSQL will return any records whenever the “exists” condition is met. EXISTS condition can be used with SELECT, INSERT, UPDATE and DELETE SQL statements. Syntax for the EXISTS condition in Oracle SQL / PLSQL is: SELECT column_name(s) FROM table_name WHERE EXISTS (subquery); Or INSERT INTO table_name VALUES(column_name1 ,column_name2 […]