Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can the columns coming up from Pivot applied as prompts?

Vibha PandeyJun 6 2024 — edited Jun 6 2024

I have a report which is brining in questions and responses (response answer/response text). I have pivotted the table to get the questions as columns and responses in subsequent rows. Now I need to apply a filter on responses of 2 of the questions from a set of 10 questions. I was able to apply the prompt, but the results is not filtering out based on what comes in the LOV.

Comments
Post Details
Added on Jun 6 2024
4 comments
224 views