Skip to Main Content

APEX

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!

Direction Right To Left in 5.1

IBRAHIM ALSRORIDec 17 2016 — edited Jan 29 2017

I have application in apex 5.0 , i try to upgrade  it to 5.1 but when i try to change direction from right to left nothing change it still the same direction( left to right) ,

and when i create new application in 5.1 and change the direction ,it changed perfect,

why the old applications can't change direction in 5.1 ,

any help please ?

This post has been answered by Patrick Wolf-Oracle on Dec 17 2016
Jump to Answer

Comments

DStrack

use the function apex_string.split to split clobs. (available since APEX 19.2)
select s.column_value from clob_tab, table(apex_string.split(clob_column,'class:abcd'||chr(10)||'}')) s;

Solomon Yakobson

Assuming you are on 12C or higher:

with sample as (
                select '{
adam smith
class:abcd
}
{
xxxyyyy
class:abcd
}
{
zzzz
class:abcd
}' data from dual
)
select  rownum,
        r
  from  sample,
        lateral(
                select  regexp_substr(data,'{[^}]*}',1,level) r
                  from  dual
                  connect by level <= regexp_count(data,'{')
               )
/

    ROWNUM R
---------- --------------------
         1 {
           adam smith
           class:abcd
           }

         2 {
           xxxyyyy
           class:abcd
           }

         3 {
           zzzz
           class:abcd
           }

SQL>

And if performance is a factor you can change REGEXP_SUBSTR with SUBSTR + INSTR and REGEXP_COUNT with LENGTH + REPLACE.
SY.

1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 26 2017
Added on Dec 17 2016
7 comments
2,726 views