The SQL EXISTS Operator. The EXISTS operator is used to test for the existence of any record in a subquery. The EXISTS operator returns true if the subquery returns one or more records. Exists and Not Exists Example - Oracle Tutorial - PL/SQL. Oracle Tutorial. Code Examples. Forms and Reports Examples Select Query DML Statements Table Joins Functions System Packages. Exists Examples Example 1. Select. From books Where EXISTS (Select. From sales s Where b.bookid = s.bookid). SQL.Plus and PL/SQL.
Attention, Internet Explorer UserAnnouncement: Oracle Community has discontinued support for Internet Explorer 7 and below.In order to provide the best platform for continued innovation, Oracle Community no longer supports Internet Explorer 7.Oracle Community will not function with this version of Internet Explorer. Please consider upgrading to a more recent version of Internet Explorer, or trying another browser such as Firefox, Safari, or Google Chrome.(Please remember to honor your company's IT policies before installing new software!).