GitHub

kadocolak/sql_server_split_string_function

Splits the text according to each : character in the example:value:data variable. The result will be a table with 3 rows.
GitHub

sample_data_string_split.sql

INSERT INTO movie (movie_title, category) VALUES ('The Avengers','action, superhero,fantasy'); INSERT INTO movie (movie_title, category) VALUES ('The Ring', 'horror ...
Ars Technica

SQL: split a variable

@%1-3 are variables that's replaced by our system. So far so good. Here's the tricky part. A new requirement is to send a part of the JobNo (@%2), to another field as well, that we might call LineNo.
Ars Technica

pl/sql: split?

Does anyone know how I might split a string into an array in pl/sql? The kind folks at Oracle chose not to include that functionality in their language, and now I'm up a creek.<BR><BR>I need to split ...