Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle sql split text into rows

aetlNov 25 2020 — edited Nov 27 2020

Hello Everyone ,
I have a clob column which has value like this :
{
adam smith
class:abcd
}
{
xxxyyyy
class:abcd
}
{
zzzz
class:abcd
}

class:abcd text is 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,

Comments

EdStevens 
4186078 wrote:
Hello guys, I want to install and Oracle 19c Single Instance DB on my server, but when running the Installer it only upgrades my old ASM. ASM Disks are deleted and the service is stopped too. What else do I have to do to remove the ASM properly to install a database rather than upgrading an exisiting one?

What is the name of the distribution file you downloaded.  There's no way a database installation should try to upgrade an ASM instance.

4186078

i think it's the ESL installer and i use the option "Setup software only"

EdStevens 
4186078 wrote:
i think it's the ESL installer and i use the option "Setup software only"

I've been working with Oracle since around 1996, and never heard of "the ESL installer".  I asked you for the name of the distribution file file you downloaded.

1 - 3

Post Details

Added on Nov 25 2020
3 comments
178 views