Description : What does an on-clear-block Trigger fire?
Last Answer : It fires just before SQL * forms the current block.
Description : Does a Before form trigger fire when the parameter form is suppressed?
Last Answer : Yes.
Description : What is transactional trigger property?
Last 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.
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 .
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.
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
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
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
Description : Can U disable database trigger? How?
Last Answer : Yes. With respect to table ALTER TABLE TABLE [[ DISABLE all_trigger ]]
Description : Can you use a commit statement within a database trigger?
Last Answer : No
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.
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.
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.
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.
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.
Description : What is a Trigger ?
Last Answer : A piece of logic that is executed at or triggered by a SQL *forms event.
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.
Description : Can we use GO-BLOCK package in a pre-field trigger ?
Description : Is a Key startup trigger fires as result of a operator pressing a key explicitly ?
Description : Can we use a restricted package procedure in ON-VALIDATE-FIELD 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.
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.
Description : When is PRE-QUERY trigger executed ?
Last Answer : When Execute-query or count-query Package procedures are invoked.
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.
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.
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.
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
Description : What is trigger associated with the timer?
Last Answer : When-timer-expired.
Description : Is the After report trigger fired if the report execution fails?
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.
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.
Description : How can a text file be attached to a report while creating in the report writer?
Last Answer : By using the link file property in the layout boiler plate property sheet.
Description : Can you have more than one content canvas view attached with a window?
Last Answer : Yes. Each window you create must have atleast one content canvas view assigned to it. You can also create a window that has manipulated content canvas view. At run time only one of the content canvas views assign to a window is displayed at a time.
Description : what is a display item?
Last Answer : Display items are similar to text items but store only fetched or assigned values. Operators cannot navigate to a display item or edit the value it contains.
Description : What are the types of triggers and how the sequence of firing in text item
Last Answer : Triggers can be classified as Key Triggers, Mouse Triggers ,Navigational Triggers. Key Triggers :: Key Triggers are fired as a result of Key action.e.g :: Key-next-field, Key-up,Key-Down Mouse Triggers :: Mouse ... :: a) pre - text b) when new item c) key-next d) when validate e) post text
Description : What is a Navigable item?
Last Answer : A navigable item is one that operators can navigate to with the keyboard during default navigation, or that Oracle forms can navigate to by executing a navigational built-in procedure.
Description : What is a list item?
Last Answer : It is a list of text elements.
Description : What are the triggers associated with the image item?
Last Answer : When-Image-activated(Fires when the operator double clicks on an image Items) When-image-pressed(fires when the operator selects or deselects the image item)
Description : What are the difference between lov & list item?
Last Answer : Lov is a property where as list item is an item. A list item can have only one column, lov can have one or more columns.
Description : With which function of summary item is the compute at options required?
Last Answer : ummary item is the compute at options required?
Description : What are the built-ins that are used to Attach an LOV programmatically to an item?
Last Answer : set_item_property get_item_property (by setting the LOV_NAME property)
Description : Can distant wildfires trigger your fire alarm?
Last Answer : Yes they can, it happened in Virginia.
Description : The words in the passage that suggest there was a blast include (1) fire, heat, confusion, overturned and chaos. (2) blazed, dazed, heroic, succumbed and paralysis. (3) broken glass, cuts, bruises and sycamores. (4) rescue, quadrangle, altruism, trigger and heat.
Last Answer : (1) fire, heat, confusion, overturned and chaos
Description : What are timers ? when when-timer-expired does not fire?
Last Answer : The When-Timer-Expired trigger can not fire during trigger, navigation, or transaction processing.
Description : As shown in the illustrations of console schematic diagrams, each circuit card and component, such as a relay or indicating lamp, has an identifier attached. This identifier, which is composed of ... where the item may actually be found on the console by section, surface and possible subassembly
Last Answer : Answer: D
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.
Description : What is OLE Activation style property?
Last Answer : Specifies the event that will activate the OLE containing item.
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.
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.
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.