How to call a hierarchical Query (connect by prior) ? : Portal

Start a new topic

Answered

How to call a hierarchical Query (connect by prior) ?

Audric FREY

started a topic over 1 year ago

Hello,

Is it possible inx DI to use the oracle function Connect by level?

I would like from a character string separated by “; in my source file, do an online conversion.

My query in the SQL editor is:

SELECT distinct RUID, trim(regexp_substr(TYPE_CODE, '[^;]+', 1, LEVEL))
FROM TMP_TEST_TYPE
CONNECT BY LEVEL <= regexp_count(TYPE_CODE, ';')+1

Best Answer

Audric FREY said over 1 year ago

Hello,

You can use a Metadata Query for your use case :

2 Comments

Audric FREY

said over 1 year ago

Answer

Hello,

You can use a Metadata Query for your use case :

Tsiky RABARIJAONA

said over 1 year ago

You can directly pur your select query in a Query Metadata : create and use a metadata query. This Query Metadata will then be usable in a mapping as a source datastore.