Use of between page triggers in REPORTS - oracle

Explain the use of between page triggers in REPORTS.

The between-page trigger is used for creating conditional formatting, eg: retrieving information to put in headers or labels that cannot be part of the main query. It is often used for reports to be viewed online as the trigger is fired each time the page is first displayed. A report that changes its format based on page number, user etc is an ideal candidate for between-page triggers.
Delete all duplicate records using subquery - oracle
Delete all duplicate records using subquery - Query: DELETE from table1 where rowid not in (select MAX(rowid) from table1 GROUP BY column_name);...
Types of trigger can be used in a table at a time - oracle
Types of trigger can be used in a table - We can use maximum of 12 triggers on a table. • BEFORE INSERT • AFTER INSERT...
What is partitioned table? What are its types and purposes? - oracle
Partitioned table - Partitioning allows decomposing large tables and indexes into smaller manageable units called partitions...
Post your comment