O'Reilly logo

Oracle Discoverer 10g Handbook by Darlene Armstrong-Smith, Michael Armstrong-Smith

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 12Building Effective Conditions

After refining the query items, and pivoting the data, perhaps the next most common way to refine a query is to refine the conditions. The ability to add, edit, or remove conditions is one of the things you need to master in order to become an expert in Discoverer.

In Chapter 4, we introduced you to the Workbook Wizard. One of the essential steps that you were shown was setting user-defined conditions. However, in that chapter, we advised you to only create enough conditions to avoid “The Query from the Twilight Zone.” Those conditions were very simple. In this section, we will show you how to build effective conditions and explain all of the options that are available to you.

Adding Conditions

The most ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required