I'm not really sure exactly how to describe what I'm asking, but this Pseudocode should make sense:
If @TYPE = 'Red' then only return records where IS_RED = True
If @TYPE = 'Green' then only return records where IS_GREEN = True
If @TYPE = 'Blue' then only return records where IS_BLUE = True
If @TYPE = 'All' then return all records
Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.