DBSkool Header Image Background

Category: Forms_ExpressivePage 1 of 3

Introducing Multiple Form Applications

1. Write down the benefits of multiple forms applications. The benefits of multiple forms applications are- ♦ Easier debugging ♦ Modularity ♦ Performance and scalability 2. How can…

Sharing Objects and Code

1. What are the benefits of reusing objects and code? Benefits of Reusing objects and code: • Increase productivity • Decrease maintenance • Increase modularity • Maintain standards…

Writing Flexible Code

1. What is flexible code? Why we write flexible code? Flexible code is code that you can use again. It is often generic code that you can use…

Transaction Processing

1. What are the characteristics of following commit triggers? Characteristics of Commit Triggers • Pre-Commit trigger : Fires once if form changes • Pre- and Post DML Trigger:…

Navigation

1. What are the navigational units? ♦ The navigational units are: ♦ Outside the form ♦ Form ♦ Block ♦ Record ♦ Item 2. When do Pre-and Post-Navigation…

Validation

1. When Does Validation Occur? Validation occurs when: • The Enter key is pressed or the ENTER build-in procedure is run • The operator or trigger leaves the…

Query Trigger

1. How you can obtain Query Information at Run Time? We can use the following system variables and built-ins to obtain information about queries: a. SYSTEM.MODE b. SYSTEM.LAST_QUERY…

Run Time messages and Alert

1. What is informative message? A message tells the user the current state of processing, or gives context-sensitive information. The default display is on the message line. 2….

Debugging Trigger

1. Write about debugging process. • Compiling and correcting errors in the PL/SQL Editor. • Displaying debug messages at run time. • Invoking the PL/SQL Debugger. 2. Write…

Producing Trigger

1. Write the steps for creating trigger? Steps for creating a trigger: Step One: Select Trigger Scope Step Two: Invoke the Trigger LOV Step Three: Use the PL/SQL…