Oracle IN vs Exists difference?

by

simply put, EXISTS is usually used for checking whether rows that meet a criteria exist in another (or the same) table.

your SQL using EXISTS would look like this:

select *
from   emp e
where  exists(select * from emp e2 where e.empno = e2.empno and e2.ename in ('smith', 'brown', 'john', 'johnson'))

so you can see it’s not what you need here

More Related Contents:

  1. How to create id with AUTO_INCREMENT on Oracle?
  2. Fetch the row which has the Max value for a column
  3. Oracle SQL: Update a table with data from another table
  4. Is there an Oracle SQL query that aggregates multiple rows into one row? [duplicate]
  5. How to handle a single quote in Oracle SQL
  6. Select count(*) from multiple tables
  7. Oracle SQL – How to Retrieve highest 5 values of a column [duplicate]
  8. Fetch the rows which have the Max value for a column for each distinct value of another column
  9. REGEX to select nth value from a list, allowing for nulls
  10. SQL to generate a list of numbers from 1 to 100
  11. How to show all privileges from a user in oracle?
  12. SQL – How to select a row having a column with max value [duplicate]
  13. Oracle: loading a large xml file?
  14. IF EXISTS condition not working with PLSQL
  15. Group by alias (Oracle)
  16. Using pivot on multiple columns of an Oracle row
  17. Sleep function in ORACLE
  18. Solution to “cannot perform a DML operation inside a query”?
  19. Split comma separated values of a column in row, through Oracle SQL query
  20. How to query a CLOB column in Oracle
  21. update columns values with column of another table based on condition [duplicate]
  22. how to select even records from a table in oracle?
  23. Oracle : select maximum value from different columns of the same row
  24. Creating or simulating two dimensional arrays in PL/SQL
  25. Using Alias In When Portion of a Case Statement in Oracle SQL
  26. Oracle string aggregation
  27. How do NULL values affect performance in a database search?
  28. Check if two “select”s are equivalent
  29. Concat function is not working – invalid number of arguments
  30. ORACLE After update trigger: solving ORA-04091 mutating table error

Leave a Comment