Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE promt help

Received Response
21
Views
1
Comments
User_SOJXT
User_SOJXT Rank 1 - Community Starter
edited Aug 13, 2024 7:21PM in Oracle Analytics Cloud and Server

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) )

Answers

  • Federico Venturin - Oracle
    Federico Venturin - Oracle Mod

    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', ',', ''',''')