Collections:
Use Subqueries with the IN Operator in Oracle
How To Use Subqueries with the IN Operator in Oracle?
✍: FYIcenter.com
A subquery can be used with the IN operator as "expression IN (subquery)". The subquery should return a single column with one or more rows to form a list of values to be used by the IN operation. The following tutorial exercise shows you how to use a subquery with the IN operator:
SQL> SELECT first_name, last_name FROM employees 2 WHERE department_id IN ( 3 SELECT department_id FROM departments 4 WHERE location_id = 1700 5 ); FIRST_NAME LAST_NAME -------------------- ------------------------- Steven King Neena Kochhar Lex De Haan Nancy Greenberg Daniel Faviet John Chen Ismael Sciarra ......
⇒ Use Subqueries with the EXISTS Operator in Oracle
⇐ What Is a Subquery in Oracle
2019-09-27, 3292🔥, 0💬
Popular Posts:
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...
How to set the current database in SQL Server? Once you are connected to the SQL Server, you should ...
How To Install Oracle Database 10g XE in Oracle? To install 10g universal edition, double click, Ora...
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...