Declarative Data Filtering

Overview

In Oracle JDeveloper, one can specify easy-to-understand names for the columns defined in the SQL query encapsulated by a view object. For example, the Managers view object in the starter workspace queries the EMP table. Although the query includes the JOB column, the corresponding view object attribute is named CompanyRole. Previous versions of Oracle JDeveloper made it possible to manually enter custom WHERE and ORDER BY clauses in a view object query, and they included an "Expert mode" that gave full control over the entire SQL statement. Although these modes are both still supported, they require one to remember the names of the underlying database columns - a tedious requirement if one is not intimately familiar with the schema.