This content has been marked as final. Show 4 replies
You can add a "Filter" operator and define a "Filter Condition".
Then link the source table to the "Filter".
Thanks Sanjay, I just wanted to check if we could use custom sql in table operator somehow. but i couldn't see option there.
When the PL/SQL code is generated, filter condition is added to the source table.
So exactly what you want is happened behind the scenes.