How can I select from list of values in Oracle

by

You don’t need to create any stored types, you can evaluate Oracle’s built-in collection types. 

select distinct column_value from table(sys.odcinumberlist(1,1,2,3,3,4,4,5))

More Related Contents:

  1. I want to search job and salary from employee table but I am getting error like invalid relational operator [closed]
  2. How do I do top 1 in Oracle? [duplicate]
  3. REGEX to select nth value from a list, allowing for nulls
  4. PLS-00428: an INTO clause is expected in this SELECT statement
  5. How to kill a running SELECT statement
  6. How do I select all the columns from a table, plus additional columns like ROWNUM?
  7. How to get the last row of an Oracle table
  8. DATEDIFF function in Oracle [duplicate]
  9. How can I get the number of days between 2 dates in Oracle 11g? [duplicate]
  10. Pivoting of data using two columns
  11. INSERT SELECT statement in Oracle 11G
  12. Sleep function in ORACLE
  13. SQL Error: ORA-00942 table or view does not exist
  14. Oracle – How to create a materialized view with FAST REFRESH and JOINS
  15. Nth max salary in Oracle
  16. Oracle – ORA-01489: result of string concatenation is too long [duplicate]
  17. Display names of all constraints for a table in Oracle SQL
  18. Autoincrement in oracle to already created table
  19. Oracle 11g – Check constraint with RegEx
  20. Issue when comparing result of to_char(myDate, ‘DAY’) to a string
  21. How to use a dynamic parameter in a IN clause of a JPA named query?
  22. Why does the wm_concat not work here?
  23. The network adapter could not establish the connection – Oracle 11g
  24. Check if two “select”s are equivalent
  25. Curious issue with Oracle UNION and ORDER BY
  26. Subtracting Dates in Oracle – Number or Interval Datatype?
  27. How to call Oracle MD5 hash function?
  28. Oracle RAC and sequences
  29. Using bind variables with dynamic SELECT INTO clause in PL/SQL
  30. Insert into from CTE

Leave a Comment