What is transactional trigger property?

What is transactional trigger property?
by

1 Answer

Answer :

Identifies a block as transactional control block. i.e. non - database
block that oracle forms should manage as transactional block.(NON-
ORACLE datasource) default - FALSE.
by

Related questions

If you have property class attached to an item and you have same trigger written for the item . Which will fire first?

Description : If you have property class attached to an item and you have same trigger written for the item . Which will fire first?

Last Answer : Item level trigger fires , If item level trigger fires, property level trigger won't fire. Triggers at the lowest level are always given the first preference. The item level trigger fires first and then the block and then the Form level trigger.

What are property classes ? Can property classes have trigger?

Description : What are property classes ? Can property classes have trigger?

Last Answer : Property class inheritance is a powerful feature that allows you to quickly define objects that conform to your own interface and functionality standards. Property classes also allow you to make global ... all objects that inherit properties from that class. Yes . All type of triggers .

What is the use of transactional triggers?

Description : What is the use of transactional triggers?

Last Answer : Using transactional triggers we can control or modify the default functionality of the oracle forms.

When the form is running in DEBUG mode, If you want to examine the values of global variables and other form variables, What package procedure command you would use in your trigger text ?

Description : When the form is running in DEBUG mode, If you want to examine the values of global variables and other form variables, What package procedure command you would use in your trigger text ?

Last Answer : Break. SYSTEM VARIABLES

Which trigger related to mouse?

Description : Which trigger related to mouse?

Last Answer : When-Mouse-Click When-Mouse-DoubleClick When-Mouse-Down When-Mouse-Enter When-Mouse-Leave When-Mouse-Move When-Mouse-Up

Which trigger are created when master -detail rela?

Description : Which trigger are created when master -detail rela?

Last Answer : master delete property * NON-ISOLATED (default) a) on check delete master b) on clear details c) on populate details * ISOLATED a) on clear details b) on populate details * CASCADE a) per-delete b) on clear details c) on populate details

Can U disable database trigger? How?

Description : Can U disable database trigger? How?

Last Answer : Yes. With respect to table ALTER TABLE TABLE [[ DISABLE all_trigger ]]

Can you use a commit statement within a database trigger?

Description : Can you use a commit statement within a database trigger?

Last Answer : No

What is Database Trigger ?

Description : What is Database Trigger ?

Last Answer : A Database Trigger is procedure (set of SQL and PL/SQL statements) that is automatically executed as a result of an insert in,update to, or delete from a table.

What are the uses of Database Trigger ?

Description : What are the uses of Database Trigger ?

Last Answer : Database triggers can be used to automatic data generation, audit data modifications, enforce complex Integrity constraints, and customize complex security authorizations.

What is a database trigger ? Name some usages of database trigger ?

Description : What is a database trigger ? Name some usages of database trigger ?

Last Answer : Database trigger is stored PL/SQL program unit associated with a specific database table. Usages are Audit data modifications, Log events transparently, Enforce complex business rules Derive column values automatically, Implement complex security authorizations. Maintain replicate tables.

Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ? Why ?

Description : Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ? Why ?

Last Answer : It is not possible. As triggers are defined for each table, if you use COMMIT of ROLLBACK in a trigger, it affects logical transaction processing.

What are two virtual tables available during database trigger execution ?

Description : What are two virtual tables available during database trigger execution ?

Last Answer : The table columns are referred as OLD.column_name and NEW.column_name. For triggers related to INSERT only NEW.column_name values only available. For triggers related to UPDATE only OLD. ... values only available. For triggers related to DELETE only OLD.column_name values only available.

What is a Trigger ?

Description : What is a Trigger ?

Last Answer : A piece of logic that is executed at or triggered by a SQL *forms event.

What is the difference between a Function Key Trigger and Key Function Trigger ?

Description : What is the difference between a Function Key Trigger and Key Function Trigger ?

Last Answer : 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 referred as key F0 through key F9.

What does an on-clear-block Trigger fire?

Description : What does an on-clear-block Trigger fire?

Last Answer : It fires just before SQL * forms the current block.

Can we use GO-BLOCK package in a pre-field trigger ?

Description : Can we use GO-BLOCK package in a pre-field trigger ?

Last Answer : No

Is a Key startup trigger fires as result of a operator pressing a key explicitly ?

Description : Is a Key startup trigger fires as result of a operator pressing a key explicitly ?

Last Answer : No

Can we use a restricted package procedure in ON- VALIDATE-FIELD Trigger ?

Description : Can we use a restricted package procedure in ON-VALIDATE-FIELD Trigger ?

Last Answer : No

What is the difference between an ON-VALIDATE-FIELD trigger and a trigger ?

Description : What is the difference between an ON-VALIDATE-FIELD trigger and a trigger ?

Last Answer : On-validate-field trigger fires, when the field Validation status New or changed. Post-field-trigger whenever the control leaving form the field, it will fire.

A query fetched 10 records How many times does a PRE- QUERY Trigger and POST-QUERY Trigger will get executed ?

Description : A query fetched 10 records How many times does a PRE-QUERY Trigger and POST-QUERY Trigger will get executed ?

Last Answer : PRE-QUERY fires once. POST-QUERY fires 10 times.

When is PRE-QUERY trigger executed ?

Description : When is PRE-QUERY trigger executed ?

Last Answer : When Execute-query or count-query Package procedures are invoked.

What is the difference between ON-VALIDATE-FIELD trigger and a POST-CHANGE trigger ?

Description : What is the difference between ON-VALIDATE-FIELD trigger and a POST-CHANGE trigger ?

Last Answer : When you changes the Existing value to null, the On-validate field trigger will fire post change trigger will not fire. At the time of execute- query post-change trigger will fire, on-validate field trigger will not fire.

At what point of report execution is the before Report trigger fired?

Description : At what point of report execution is the before Report trigger fired?

Last Answer : After the query is executed but before the report is executed and the records are displayed.

What is WHEN-Database-record trigger?

Description : What is WHEN-Database-record trigger?

Last Answer : Fires when oracle forms first marks a record as an insert or an update. The trigger fires as soon as oracle forms determines through validation that the record should be processed by the next post or ... the first item in the record, and after the operator attempts to navigate out of the item.

What are the trigger associated with image items?

Description : What are the trigger associated with image items?

Last Answer : When-image-activated fires when the operators double clicks on an image itemwhen-image-pressed fires when an operator clicks or double clicks on an image item

What is trigger associated with the timer?

Description : What is trigger associated with the timer?

Last Answer : When-timer-expired.

Does a Before form trigger fire when the parameter form is suppressed?

Description : Does a Before form trigger fire when the parameter form is suppressed?

Last Answer : Yes.

Is the After report trigger fired if the report execution fails?

Description : Is the After report trigger fired if the report execution fails?

Last Answer : Yes.

What is database Trigger?

Description : What is database Trigger?

Last Answer : A database trigger is a PL/SQL block that can defined to automatically execute for insert, update, and delete statements against a table. The trigger can e defined to execute once for the ... define database triggers. A database trigger can call database procedures that are also written in PL/SQL.

If the maximum record retrieved property of the query is set to 10 then a summary value will be calculated?

Description : If the maximum record retrieved property of the query is set to 10 then a summary value will be calculated?

Last Answer : Only for 10 records.

What is OLE Activation style property?

Description : What is OLE Activation style property?

Last Answer : Specifies the event that will activate the OLE containing item.

What is Current record attribute property?

Description : What is Current record attribute property?

Last Answer : Specifies the named visual attribute used when an item is part of the current record. Current Record Attribute is frequently used at the block level to display the current row in a multi-record ... current record, but you cannot dynamically highlight the current item, as the input focus changes.

Diff. between VAT and Property Class? imp

Description : Diff. between VAT and Property Class? imp

Last Answer : Named visual attributes define only font, color, and pattern attributes; property classes can contain these and any other properties. You can change the appearance of objects at runtime by ... visual attribute settings take precedence, and any visual attribute properties in the class are ignored.

What is mouse navigate property of button?

Description : What is mouse navigate property of button?

Last Answer : When Mouse Navigate is True (the default), Oracle Forms performs standard navigation to move the focus to the item when the operator activates the item with the mouse. When Mouse Navigate is set ... the resulting validation) to move to the item when an operator activates the item with the mouse.

What is SECURE property?

Description : What is SECURE property?

Last Answer : Hides characters that the operator types into the text item. This setting is typically used for password protection.

What is a property clause?

Description : What is a property clause?

Last Answer : A property clause is a named object that contains a list of properties and their settings. Once you create a property clause you can base other object on it. An object based on a property can inherit the setting of any property in the clause that makes sense for that object.

How is it possible to select generate a select set for the query in the query property sheet?

Description : How is it possible to select generate a select set for the query in the query property sheet?

Last Answer : By using the tables/columns button and then specifying the table and the column names.

What is the remove on exit property?

Description : What is the remove on exit property?

Last Answer : For a modelless window, it determines whether oracle forms hides the window automatically when the operators navigates to an item in the another window.

To execute row from being displayed that still use column in the row which property can be used?

Description : To execute row from being displayed that still use column in the row which property can be used?

Last Answer : Format trigger.

What are the different default triggers created when Master Deletes Property is set to Cascade?

Description : What are the different default triggers created when Master Deletes Property is set to Cascade?

Last Answer : Master Deletes Property Resulting Triggers --------------------------------------------------- Cascading On-Clear-Details On-Populate-Details Pre-delete

What are the different default triggers created when Master Deletes Property is set to isolated?

Description : What are the different default triggers created when Master Deletes Property is set to isolated?

Last Answer : Master Deletes Property Resulting Triggers --------------------------------------------------- Isolated On-Clear-Details On-Populate-Details

What are the different default triggers created when Master Deletes Property is set to Non-isolated?

Description : What are the different default triggers created when Master Deletes Property is set to Non-isolated?

Last Answer : Master Deletes Property Resulting Triggers ---------------------------------------------------- Non-Isolated(the default) On-Check-Delete-Master On-Clear-Details On-Populate-Details

What is the purpose of the product order option in the column property sheet?

Description : What is the purpose of the product order option in the column property sheet?

Last Answer : To specify the order of individual group evaluation in a cross products.

What is the "LOV of Validation" Property of an item? What is the use of it?

Description : What is the "LOV of Validation" Property of an item? What is the use of it?

Last Answer : When LOV for Validation is set to True, Oracle Forms compares the current value of the text item to the values in the first column displayed in the LOV. Whenever the validation event occurs. If ... the LOV and uses the text item value as the search criteria to automatically reduce the list.

What are the sql clauses supported in the link property sheet?

Description : What are the sql clauses supported in the link property sheet?

Last Answer : Where start with having.

Can a property clause itself be based on a property clause?

Description : Can a property clause itself be based on a property clause?

Last Answer : Yes

What is Lossless join property?

Description : What is Lossless join property?

Last Answer : It guarantees that the spurious tuple generation does not occur with respect to relation schemas after decomposition.

Mention the services which are provided by transactional category of an E_banking. -Technology

Description : Mention the services which are provided by transactional category of an E_banking. -Technology

Last Answer : There are no geographical barriers and the services that can be offered at a minimum cost. Through Internet banking, you can check your transactions at any time and as many times as you want to. ... transaction. e.g. a customer login to his or her bank account by accessing the bank Website.

What are the differences between Transactional Analysis and person centred therapy?

Description : What are the differences between Transactional Analysis and person centred therapy?

Last Answer : Need answer