Description : How can you execute the user defined triggers in forms 3.0 ?
Last Answer : Execute Trigger (trigger-name)
Description : What are the built-in routines is available in forms 4.0 to create and manipulate a parameter list?
Last Answer : Add_parameter Create_Parameter_list Delete_parameter Destroy_parameter_list Get_parameter_attr Get_parameter_list set_parameter_attr
Description : List system variables available in forms 4.0, and not available in forms 3.0?
Last Answer : System.cordination_operation System Date_threshold System.effective_Date System.event_window System.suppress_working
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 are Database Triggers and Stored Procedures
Last Answer : Database Triggers :: Database Triggers are Procedures that are automatically executed as a result of insert in, update to, or delete from table. Database triggers have the values old and new to ... procedures is that many users can use the same procedure in compiled and ready to use format.
Description : Difference between database triggers and form triggers?
Last Answer : Data base trigger(DBT) fires when a DML operation is performed on a data base table. Form trigger(FT) Fires when user presses a key or navigates between fields on the screen -Can be row ... other database triggers to fire.Can cause other database triggers to fire, but not other form triggers.
Description : How many types of database triggers can be specified on a table ? What are they ?
Last Answer : Insert Update Delete Before Row o.k. o.k. o.k. After Row o.k. o.k. o.k. Before Statement o.k. o.k. o.k. After Statement o.k. o.k. o.k. If FOR EACH ROW clause is ... for each Row affected by the statement. If WHEN clause is specified, the trigger fires according to the returned Boolean value.
Description : What are the triggers associated with a check box?
Last Answer : Only When-checkbox-activated Trigger associated with a Check box.
Description : What triggers are associated with the radio group?
Last Answer : Only when-radio-changed trigger associated with radio group Visual Attributes.
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 types of TRIGGERS ?
Last Answer : 1. Navigational Triggers. 2. Transaction Triggers.
Description : What are the different types of key triggers ?
Last Answer : Function Key Key-function Key-others Key-startup
Description : State the order in which these triggers are executed ?
Last Answer : POST-FIELD,ON-VALIDATE-FIELD,POST-CHANGE and KEY-NEXTFLD. KEY-NEXTFLD,POST-CHANGE, ON-VALIDATE-FIELD, POST-FIELD. g.
Description : Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?
Last Answer : a. ON-INSERT b. POST-INSERT c. PRE-INSERT
Description : What is the usage of an ON-INSERT,ON-DELETE and ON-UPDATE TRIGGERS ? These triggers are execu
Last Answer : 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.
Description : Give the sequence of execution of the various report triggers?
Last Answer : Before form , After form , Before report, Between page, After report.
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
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
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
Description : What are the master-detail triggers?\
Last Answer : On Check_delete_masterOn_clear_detailsOn_populate_details
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.
Description : What are the design facilities available in forms 4.0?
Last Answer : Default Block facility. Layout Editor. Menu Editor. Object Lists. Property Sheets. PL/SQL Editor. Tables Columns Browser. Built-ins Browser.
Description : What is a predefined exception available in forms 4.0?
Last Answer : Raise form_trigger_failure
Description : List the editors availables in forms 4.0?
Last Answer : Default editor User_defined editors system editors.
Description : How image_items can be populate to field in forms 4.0?
Last Answer : A fetch from a long raw database column PL/Sql assignment to executing the read_image_file built_in procedure to get an image from the file system.
Description : What is a library in Forms 4.0?
Last Answer : A library is a collection of Pl/SQL program units, including user named procedures, functions & packages
Description : Give the equivalent term in forms 4.0 for the following. Page, Page 0?
Last Answer : Page - Canvas-View Page 0 - Canvas-view null.
Description : What are the menu items that oracle forms 4.0 supports?
Last Answer : Plain, Check,Radio, Separator, Magic
Description : What is the significance of PAGE 0 in forms 3.0 ?
Last Answer : Hide the fields for internal calculation.
Description : How do you trap the error in forms 3.0 ?
Last Answer : using On-Message or On-Error triggers.
Description : What is the use of break group? What are the various sub events a mouse double click event involves?
Last Answer : A break group is used to display one record for one group ones. While multiple related records in other group can be displayed.
Description : What are the various sub events a mouse double click event involves? What are the various sub events a mouse double click event involves?
Last Answer : Double clicking the mouse consists of the mouse down, mouse up, mouse click, mouse down & mouse up events.
Description : What is an anchoring object & what is its use? What are the various sub events a mouse double click event involves?
Last Answer : An anchoring object is a print condition object which used to explicitly or implicitly anchor other objects to itself.
Description : What is a database EVENT and how does one set it? (for DBA
Last Answer : Oracle trace events are useful for debugging the Oracle database server. The following two examples are simply to demonstrate syntax. Refer to later notes on this page for an explanation of what these ... changes to the INIT.ORA file will affect all sessions once the database has been restarted.
Description : What is coordination Event?
Last Answer : Any event that makes a different record in the master block the current record is a coordination causing event.
Description : What are the default parameter that appear at run time in the parameter screen? What are the various sub events a mouse double click event involves?
Last Answer : Destype and Desname.
Description : What is the use of hidden column? What are the various sub events a mouse double click event involves?
Last Answer : A hidden column is used to when a column has to embed into boilerplate text.
Description : What is the use of place holder column? What are the various sub events a mouse double click event involves?
Last Answer : A placeholder column is used to hold calculated values at a specified place rather than allowing is to appear in the actual row where it has to appear.
Description : How can a break order be created on a column in an existing group? What are the various sub events a mouse double click event involves?
Last Answer : By dragging the column outside the group.
Description : How many different triggers are available in Report?
Last Answer : There are five types of triggers in report 6i 1) Before report trigger 2) After report trigger 3) Before Parameter trigger 4) After parameter trigger 5) Between pages trigger
Description : What are the two ways to incorporate images into a oracle forms application?
Last Answer : Boilerplate Images Image_items
Description : How do you call other Oracle Products from Oracle Forms?
Last Answer : Run_product is a built-in, Used to invoke one of the supported oracle tools products and specifies the name of the document or module to be run. If the called product is unavailable at the time of the call, Oracle Forms returns a message to the operator.
Description : When a form is invoked with call_form, Does oracle forms issues a save point?
Last Answer : Yes
Description : For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame?
Description : Can u have VBX and OCX controls in forms ?
Last Answer : Yes.
Description : Can u have OLE objects in forms?
Description : Can u set default font in forms?
Last Answer : Yes. Change windows registry(regedit). Set form45_font to the desired font.
Description : Can you issue DDL in forms?
Last Answer : yes, but you have to use FORMS_DDL. Referencing allows you to create objects that inherit their functionality and appearance from other objects. Referencing an object is similar to copying an ... values of bind variables can be concatenated into the string before passing the result to FORMS_DDL.
Description : Is forms 4.5 object oriented tool ? why?
Last Answer : yes , partially. 1) PROPERTY CLASS - inheritance property 2) OVERLOADING : procedures and functions.