Oracle Analytics and AI

User_SOJXT

Hi,

OBIEE promt sapmle 1,2 promt replace '1','2'. easy method ?

There are 70 billion rows of records and there is a performance problem when in list

Thank you.

low performance

rtrim(Varchar_ID ) In 

  ( select rtrim(deger ) as deger from( select regexp_substr('@{ID_BAR}[@]{TRIM(0)}','[^,]+', 1, level) as deger

    from dual

    connect BY regexp_substr('@{ID_BAR}[@]{TRIM(0)}', '[^,]+', 1, level) 

    is not null))

    and '@{ID_BAR}[@]{TRIM(0)}' !='0' -- promt null then false

this not work ->filter in replace -> RTRIM(REPLACE( '290 ,21295323256434393972159779' , CHR(44), 

CHR(39)||CHR(44)||CHR(39) )

Federico Venturin - Oracle

Hi @User_SOJXT ,

If I understood correctly you would like to replace each comma in a string with ',' .

To achieve this you can use the REPLACE function as follows (single quotes in a string must be escaped with one more single quote in front of them):

REPLACE('290 ,21295323256434393972159779', ',', ''',''')