Hello Everyone ,
I have a clob column which has value like this :
{
adam smith
class:abcd
}
{
xxxyyyy
class:abcd
}
{
zzzz
class:abcd
}
class:abcd characters are common all between {}
İ want to split into rows after each class:abcd} :
row 1:{
adam smith
class:abcd
}
row2:{
adam smith
class:abcd
}
row3:{
adam smith
class:abcd
}
I tried to use connect by but i didnt do it exactly.
How can i split this text into rows ?
Regards,