Split function in oracle to comma separated values with automatic sequence

by

Here is how you could create such a table:

 SELECT LEVEL AS id, REGEXP_SUBSTR('A,B,C,D', '[^,]+', 1, LEVEL) AS data
   FROM dual
CONNECT BY REGEXP_SUBSTR('A,B,C,D', '[^,]+', 1, LEVEL) IS NOT NULL;

With a little bit of tweaking (i.e., replacing the , in [^,] with a variable) you could write such a function to return a table.

More Related Contents:

  1. Place to store PL/SQL block [closed]
  2. ANYONE CAN TELL ME THAT WHY THIS CODE IS GIVING ME AN ERROR OF TABLE OT CLUSTER KEY WORD IS MISSING? [closed]
  3. Get counts of all tables in a schema
  4. Printing the value of a variable in SQL Developer
  5. PL/SQL – Use “List” Variable in Where In Clause
  6. UTL_FILE.FOPEN() procedure not accepting path for directory?
  7. Oracle stored procedure with parameters for IN clause
  8. PL/SQL ORA-01422: exact fetch returns more than requested number of rows
  9. check if “it’s a number” function in Oracle
  10. ORA-06508: PL/SQL: could not find program unit being called
  11. Split String by delimiter position using oracle SQL
  12. How to return a resultset / cursor from a Oracle PL/SQL anonymous block that executes Dynamic SQL?
  13. How to send email using Oracle 10 g Forms
  14. SQL*Plus how to accept text variable from prompt?
  15. SQL Fiddle Output Error
  16. oracle PL/SQL how to calculate range ip for IPv6 cidr
  17. if (select count(column) from table) > 0 then
  18. Why cannot I use bind variables in DDL/SCL statements in dynamic SQL?
  19. Is there a function to split a string in Oracle PL/SQL?
  20. Trying to export a Oracle via PL/SQL gives a date of 0000-00-00
  21. Oracle: how to INSERT if a row doesn’t exist
  22. Functions vs procedures in Oracle
  23. How to see refcursor result/output in Oracle SQL Developer? [duplicate]
  24. Oracle- Split string comma delimited (string contains spaces and consecutive commas)
  25. Reading clob line by line with pl\sql
  26. Why cannot I create triggers on objects owned by SYS?
  27. How to call an Oracle function with a Ref Cursor as Out-parameter from C#?
  28. No more data to read from socket
  29. automating rollback script oracle
  30. How do I get column datatype in Oracle with PL-SQL with low privileges?

Leave a Comment