Using the “IN” clause with a comma delimited string from the output of a replace() function in Oracle SQL

by

The general approach in this case would be to parse the comma-separated list into an Oracle collection and to use that collection in your SQL statement. Tom Kyte has an example of this in his discussion on variable IN lists.

Assuming you create the myTableType type and the in_list function from that thread, you should be able to do

SELECT *
  FROM employee
 WHERE employee_number IN (
    SELECT *
      FROM TABLE( in_list( p_your_comma_separated_list ) )
    )

More Related Contents:

  1. Calculate difference between 2 date / times in Oracle SQL
  2. Can you SELECT everything, but 1 or 2 fields, without writer’s cramp?
  3. List of foreign keys and the tables they reference in Oracle DB
  4. How to generate entire DDL of an Oracle schema (scriptable)?
  5. ORA-28040: No matching authentication protocol exception
  6. hibernate oracle sequence produces large gap
  7. How to get records randomly from the oracle database?
  8. Oracle PL/SQL – Raise User-Defined Exception With Custom SQLERRM
  9. Auto Increment for Oracle
  10. Oracle Search all tables all columns for string [duplicate]
  11. Oracle PL/SQL – How to create a simple array variable?
  12. creating parameterized views in oracle11g
  13. Number of rows affected by an UPDATE in PL/SQL
  14. Oracle’s default date format is YYYY-MM-DD, WHY?
  15. Default Schema in Oracle Connection URL
  16. Spool Command: Do not output SQL statement to file
  17. Convert epoch to date in sqlplus / Oracle
  18. Why are Oracle table/column/index names limited to 30 characters?
  19. What is the difference between precision and scale?
  20. Is there any way to have the JBoss connection pool reconnect to Oracle when connections go bad?
  21. Get ID of last inserted record in oracle db
  22. oracle SQL plus how to end command in SQL file?
  23. Why is the GETDATE() an invalid identifier
  24. ORA-04091: table [blah] is mutating, trigger/function may not see it
  25. Cursor For Loop with dynamic SQL-Statement
  26. How to use parameters in a ‘where value in…’ clause?
  27. How to generate a version 4 (random) UUID on Oracle?
  28. Find out the history of SQL queries
  29. How to test an Oracle Stored Procedure with RefCursor return type?
  30. Getting Error – ORA-01858: a non-numeric character was found where a numeric was expected

Leave a Comment