hoogenm · April 30, 2024 15:56
diff --git a/split_string_oracle.txt b/split_string_oracle.txt
 select regexp_substr('1,2,3,4','[^,]+', 1, level)
   from dual
 connect by regexp_substr('1,2,3,4', '[^,]+', 1, level) is not null;

 -- Nice, smart, declarative way to split a comma-delimited string in Oracle SQL.
 -- From: https://forums.oracle.com/ords/apexds/post/the-fastest-way-to-convert-comma-separated-list-into-table-3353
 -- This may be slow for a long string, but for parsing a config value this results in concise code and may prevent boilerplate code.
 -- Replace the 'copied & pasted' string (e.g. '1,2,3,4' in the example above) by one variable/constant in PL/SQL.
	select regexp_substr('1,2,3,4','[^,]+', 1, level)
	from dual
	connect by regexp_substr('1,2,3,4', '[^,]+', 1, level) is not null;

	-- Nice, smart, declarative way to split a comma-delimited string in Oracle SQL.
	-- From: https://forums.oracle.com/ords/apexds/post/the-fastest-way-to-convert-comma-separated-list-into-table-3353
	-- This may be slow for a long string, but for parsing a config value this results in concise code and may prevent boilerplate code.
	-- Replace the 'copied & pasted' string (e.g. '1,2,3,4' in the example above) by one variable/constant in PL/SQL.