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 25 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 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,
This post has been answered by Paulzip on Nov 26 2020
Jump to Answer

Comments

John JB Brock-Oracle

What version of JET are you working with?
This looks like you may have the script module hardcoded to main.js in your index.html file, and we change that name to bundle.js when using --release. In the more recent versions of the JET Starter templates, injector tags are using in the index.html to update the requirejs main module name at build time.

  <!-- This injects script tags for the main javascript files -->
  <!-- injector:scripts -->
  <!-- endinjector -->
renangi

Ojet 9.2 migrated to Ojet 11

Look in your applications index.html for the lines that I provided above. If they don't exist and/or there are hardcoded strings for the require.js and main entries, add/replace with what I shared above.

renangi

<!-- This is the main css file for the default theme -->
<!-- injector:theme -->
<link rel="stylesheet" href="css/libs/oj/v9.2.0/redwood/oj-redwood-min.css" type="text/css" />
<!-- endinjector -->
i have above code in my index.html,

That is not the same injectors that I posted about. Those are the theme injectors at the top of the file. Look at the bottom of your index.html file as I posted early.

1 - 5

Post Details

Added on Nov 25 2020
7 comments
466 views