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
Skip to content
  • Register
    • Get Started: AI Resources for Oracle Cloud HCM – Go Here

    Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

    Query taking more time to split,compare using regexp_substr() function

    edited Dec 5, 2018 12:36PM in Reporting and Analytics for HCM 3 comments

    Summary

    Query taking more time to split,compare using regexp_substr() function

    Content

    Hi ,
     
    i have a report to get goal approvers names w.r.t. goal if pending with approvers.  HRC_TXN_DATA table has a column having goal ids which are submitted to approvals.So i need to put in condition on that column.but there column value is comma seperated string.
    Ex : Attributte10 value is '300000016429008,300000016429011,300000016429029,300000016429026,300000016429020,300000016429023'
     
     So i need to keep join like this.
     AND HG.previous_state_goal_id in (txnd.ATTRIBUTE10)
     
     So i got some examples quaries using  
     select * from emp where ename in (
    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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