Library Page |
Scenario Examples |
CrossEdition Triggers |
CrossEdition triggers are used to populate columns in the new version of the application from columns in the previously existing version of the table. The reverse is also true. |
Editions |
An edition is a new type of database object that makes possible the magic that is editioning. |
Editioning Views |
Editioning views are a special type of view used to present to each edition those table columns that are appropriate for users of that edition's application code. |
Editioning Demo 1 |
This demo covers edition creation, edition commenting, editionable objects, and making editioned objects visible to application users. |
Editioning Demo 2 |
This demo builds on demo 1 and demonstrates the use of editioning views. |
Editioning Demo 3 |
This demo builds on demo 2 and demonstrates the use of crossedition triggers and the FOLLOWS and PRECEDES clauses. |
Editioning Demo 4 |
This demo shows two methods of updating a table due to column modifications specific to editioning. |
Editioning Demo 5 |
This demo shows how to use invisible indexes to make new, post-upgrade, indexes invisible to the pre-upgrade application |
Editioning Demo 6 |
This demo shows how to automate the process renaming tables, creating editioning views, and recreating DML triggers. |
Editioning Demo 7 |
This demo shows how to patch a PL/SQL object while it is in use. |