A script-enabled browser is required for this page to function properly.

About Controlling Inserts, Updates, and Deletes

Oracle Forms provides a set of properties and triggers that you can use to allow, prevent, or modify inserts, updates, and deletes in a form.

Set the following properties to control whether a block supports inserts, updates, and deletes:

At the item level, set the following properties to control inserts and updates:


About controlling inserts

About controlling updates

Insert Allowed (Block) property

Insert Allowed (Item) property

Update Allowed (Block) property

Update Allowed (Item) property

Update Only if NULL property

Delete Allowed property