How is the split function used in Oracle?
The SPLIT function in Oracle database is used to split a string into multiple substrings based on a specified delimiter, and return the results in rows. The syntax is as follows:
Divide the string into separate parts based on the specified delimiter.
Explanation of parameters:
- String: The string to be split.
- Delimiter: a separator used to split strings.
Retrieve the value from the column by splitting the string ‘Hello,World’ at each comma.
The above example splits the string ‘Hello,World’ into two substrings separated by a comma, and returns them on separate lines.
value in a column
Greetings,
Earth
