Run a query based on the output of a condition in Oracle sql
I have this table with a column name “InformationType”. Now based on the value of the informationType, I want to run another query.
what would the oracle sql query be to split values in columns?
I want to split values i a column into n sections considering ~ as the delimiter. And I want to do this for all values in that column assuming the length of characters of each section changes.