What are Query by Example reports?

Query by Example (QBE) reports allows end users to query, insert, update, and delete values into a database table or view. In the QBE build wizard, you choose which data to display in the report. Or, you can allow end users to make their own queries in the QBE report's customization form. The customization form shown below is for a QBE report based on the SCOTT.EMP table.

Users can insert, update and delete records by clicking buttons on the customization form. Or, they can use the customization form to query SCOTT.EMP, then update or delete rows directly from the the report itself, as shown below.

You can highlight report rows, columns, or data in a single cell that satisfy conditions you specify. In the above example, if an employee makes over %2500, their name and salary is highlighted and underlined.

Related topics

What are reports?