Computer Tutorials
Earn Money From Internet
Cheap Freelancers
Ask An Expert
Register Cheap Domain
Data Recovery
Best Mutual Funds
Trading Forex Online
Cheap Web Hosting
Ajax Tutorials
Cheap Cell Phone Plans
Free Mobile Learning
Job Portal
Photoshop Tutorials
Cheap Jewelry
Cheapest Air Travel
Oracle Interview Questions And Answers
|
Page 34 of 95
A piece of logic that is executed at or triggered by a SQL *forms event. 9. What are the types of TRIGGERS ? 1. Navigational Triggers. 2. Transaction Triggers. 10. What are the different types of key triggers ? Function Key Key-function Key-others Key-startup 11. What is the difference between a Function Key Trigger and Key Function Trigger ? Function key triggers are associated with individual SQL*FORMS function keys You can attach Key function triggers to 10 keys or key sequences that normally do not perform any SQL * FORMS operations. These keys refered as key F0 through key F9. 12. What does an on-clear-block Trigger fire? It fires just before SQL * forms the current block. 13. How do you trap the error in forms 3.0 ? using On-Message or On-Error triggers. 14. State the order in which these triggers are executed ? POST-FIELD,ON-VALIDATE-FIELD,POST-CHANGE and KEY-NEXTFLD. KEY-NEXTFLD,POST-CHANGE, ON-VALIDATE-FIELD, POST-FIELD. 15. What is the usuage of an ON-INSERT,ON-DELETE and ON-UPDATE TRIGGERS ? These triggers are executes when inserting,deleting and updating operations are performed and can be used to change the default function of insert,delete or update respectively. For Eg, instead of inserting a row in a table an existing row can be updated in the same table. 16. When will ON-VALIDATE-FIELD trigger executed ? It fires when a value in a field has been changed and the field status is changed or new and the key has been pressed. If the field status is valid then any further change to the value in the field will not fire the on-validate-field trigger. |