PL/SQL Editor BACK | 1 2 3 | NEXT | ToolMap

Remember how end users must click the Execute Query button to display data each time they start the application? To solve this minor distraction, create a When-New-Form-Instance trigger that automatically queries all records from the database when end users start the application. The first step is to select the object to which the trigger is attached. Next, select a trigger type. Triggers fall into five categories: ON, WHEN, PRE, POST, and KEY. These prefixes indicate when the trigger code is executed. The final step is to use the PL/SQL Editor to write and compile the trigger code.