Skip to main content

Oracle Forms - Types of Triggers

1) Block Processing Triggers

2) Interface Event Triggers

3) Master/Detail Triggers

4) Message-Handling Triggers

5) Navigational Triggers

6) Query-Time Triggers

7) Transactional Triggers

8) Validation Triggers

Comments

Post a Comment

Popular posts from this blog

Oracle Reports - Changing the current mode (Confine or Flex)

To set or override Confine mode:  In the Paper Layout view, click  Confine On or Confine Off  in the toolbar to toggle the mode: On: child objects cannot be moved outside their enclosing parent objects. Off: child objects can be moved outside their enclosing parent objects. To set or override Flex mode:  In the Paper Layout view, click  Flex On or  Flex Off in the toolbar to toggle the mode: On: parent borders "stretch" when child objects are moved against them. The child object maintains the same distance from the side it moves against. Off: parent borders remain fixed when child objects are moved against them.
Post a Comment
Read more

Difference Between CASE and DECODE?

– CASE is a expression – DECODE is a function - CASE expression is ANSI SQL Statement - DECODE is specific to Oracle Syntax - CASE syntax contains WHEN and THEN  - DECODE will not have this - CASE allow expressions or Scalar Sub query Expressions inside the CASE statement - DECODE won't allow expressions inside the DECODE function
1 comment
Read more