Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
How do I add a filter in OAC with a regexp_like condition? — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How do I add a filter in OAC with a regexp_like condition?

edited Jul 6, 2020 2:34PM in Oracle Analytics


I need to create a report in OAC by joining two tables based on regexp_like condition. How do I specify this in OAC?



I've two separate datasets pointing to two different tables (Merged_DS_Table and Operation_List) in OAC.

I've created a report in OAC by including both the datasets and this has auto-created join between the two datasets based on the common columns between them (cs_method and cs_uri). Below is the query, it has internally used for the join condition

select * from Merged_DS_Table a, Operation_List b where a.cs_method=b.cs_method and a.cs_uri = b.cs_uri;

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!