Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Apply filter in Oracle View

user12251389Aug 26 2020 — edited Aug 26 2020

I have below view where i just wanted to apply small filter such that for example i want to ignore or remove all rows for each IDENTIFIER from the View where member_descr = 'O' and member_ratio > = -5.

I am not sure if i want to create new Union condition or apply filter where i am calculating value for member_ratio value for member_descr = 'O'

Currently in the fiddle we can see the member_ratio value is 15.32778 for member_descr = 'O' which is ok for Identifier I0000RTERER3 after calculation. But after calculation for member_descr = 'O'  if the member_ratio >= -5 then i want to ignore or remove all the rows for this identifier from view.
This post has been answered by Frank Kulash on Aug 26 2020
Jump to Answer

Comments

Post Details

Added on Aug 26 2020
#oracle, #sql
16 comments
275 views