How can you execute the user defined triggers in forms 3.0 ?

How can you execute the user defined triggers in forms
3.0 ?
by

1 Answer

Answer :

Execute Trigger (trigger-name)
by

Related questions

List the windows event triggers available in Forms 4.0?

Description : List the windows event triggers available in Forms 4.0?

Last Answer : When-window-activated, when-window-closed, when-window-deactivated, when-window-resized

Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?

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

An open form can not be execute the call_form procedure if you chain of called forms has been initiated by another open form?

Description : An open form can not be execute the call_form procedure if you chain of called forms has been initiated by another open form?

Last Answer : True

Which of the following is correct? a) Module A uses Module B if a correct version of B must be present for A to execute correctly b) Module A calls (or invokes ) module B if B triggers execution of A c) All of the mentioned d) None of the mentioned

Description : Which of the following is correct? a) Module A uses Module B if a correct version of B must be present for A to execute correctly b) Module A calls (or invokes ) module B if B triggers execution of A c) All of the mentioned d) None of the mentioned

Last Answer : Module A uses Module B if a correct version of B must be present for A to execute correctly

What are the types of triggers and how the sequence of firing in text item

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

What are Database Triggers and Stored Procedures

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.

Difference between database triggers and form triggers?

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.

How many types of database triggers can be specified on a table ? What are they ?

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.

What are the triggers associated with a check box?

Description : What are the triggers associated with a check box?

Last Answer : Only When-checkbox-activated Trigger associated with a Check box.

What triggers are associated with the radio group?

Description : What triggers are associated with the radio group?

Last Answer : Only when-radio-changed trigger associated with radio group Visual Attributes.

What are the triggers associated with the image item?

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)

What are the types of TRIGGERS ?

Description : What are the types of TRIGGERS ?

Last Answer : 1. Navigational Triggers. 2. Transaction Triggers.

What are the different types of key triggers ?

Description : What are the different types of key triggers ?

Last Answer : Function Key Key-function Key-others Key-startup

State the order in which these triggers are executed ?

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.

What is the usage of an ON-INSERT,ON-DELETE and ON- UPDATE TRIGGERS ? These triggers are execu

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.

Give the sequence of execution of the various report triggers?

Description : Give the sequence of execution of the various report triggers?

Last Answer : Before form , After form , Before report, Between page, After report.

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 are the master-detail triggers?\

Description : What are the master-detail triggers?\

Last Answer : On Check_delete_masterOn_clear_detailsOn_populate_details

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.

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.

How can you execute a script file in SQLPLUS?

Description : How can you execute a script file in SQLPLUS?

Last Answer : To execute a script file in SQLPlus, type @ and then the file name.

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied?

Description : If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied?

Last Answer : While both reports 2.0 and 2.5 create the parameter, report 2.5 gives a message that a bind parameter has been created.

How image_items can be populate to field in forms 4.0?

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.

What is a library in Forms 4.0?

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

What are the built-in routines is available in forms 4.0 to create and manipulate a parameter list?

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

What are the design facilities available in forms 4.0?

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.

List the editors availables in forms 4.0?

Description : List the editors availables in forms 4.0?

Last Answer : Default editor User_defined editors system editors.

Give the equivalent term in forms 4.0 for the following. Page, Page 0?

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.

What are the menu items that oracle forms 4.0 supports?

Description : What are the menu items that oracle forms 4.0 supports?

Last Answer : Plain, Check,Radio, Separator, Magic

What is a predefined exception available in forms 4.0?

Description : What is a predefined exception available in forms 4.0?

Last Answer : Raise form_trigger_failure

List system variables available in forms 4.0, and not available in forms 3.0?

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

What is the significance of PAGE 0 in forms 3.0 ?

Description : What is the significance of PAGE 0 in forms 3.0 ?

Last Answer : Hide the fields for internal calculation.

How do you trap the error in forms 3.0 ?

Description : How do you trap the error in forms 3.0 ?

Last Answer : using On-Message or On-Error triggers.

What are the Built-ins to display the user-named editor?

Description : What are the Built-ins to display the user-named editor?

Last Answer : A user named editor can be displayed programmatically with the built in procedure SHOW-EDITOR, EDIT_TETITEM independent of any particular text item.

What are the roles and user accounts created automatically with the database?

Description : What are the roles and user accounts created automatically with the database?

Last Answer : DBA - role Contains all database system privileges. SYS user account - The DBA role will be assigned to this account. All of the base tables and views for the database's dictionary ... administrative information and internal tables and views used by oracle tools are created using this username.

When creating a user, what permissions must you grant to allow them to connect to the database?

Description : When creating a user, what permissions must you grant to allow them to connect to the database?

Last Answer : Grant the CONNECT to the user.

When a user process fails, what background process cleans up after it?

Description : When a user process fails, what background process cleans up after it?

Last Answer : PMON

Does user exits supports DLL on MSWINDOWS ?

Description : Does user exits supports DLL on MSWINDOWS ?

Last Answer : YES .

Can you call WIN-SDK thruo' user exits?

Description : Can you call WIN-SDK thruo' user exits?

Last Answer : YES.

What are user-exits?

Description : What are user-exits?

Last Answer : It invokes 3GL programs.

How does one switch to another user in Oracle? (for DBA

Description : How does one switch to another user in Oracle? (for DBA

Last Answer : Users normally use the "connect" statement to connect from one database user to another. However, DBAs can switch from one user to another without a password. Of course it is not advisable to ... tiger Connected. Note: Also see the su.sql script in the Useful Scripts and Sample Programs Page.

Who created all these users in my database?/ Can I drop this user? (for DBA

Description : Who created all these users in my database?/ Can I drop this user? (for DBA

Last Answer : Oracle creates a number of default database users or schemas when a new database is created. Below are a few of them: SYS/CHANGE_ON_INSTALL or INTERNAL Oracle Data Dictionary/ Catalog Created ... there should be no problem altering these users to use a different default and temporary tablespace.

What are various privileges that a user can grant to another user?

Description : What are various privileges that a user can grant to another user?

Last Answer : SELECT -CONNECT -RESOURCES

What is an User Exits ?

Description : What is an User Exits ?

Last Answer : A user exit is a subroutine which are written in programming languages using pro*C pro *Cobol , etc., that link into the SQL * forms executable.

What are the type of User Exits ?

Description : What are the type of User Exits ?

Last Answer : ORACLE Precompliers user exits OCI (ORACLE Call Interface) Non-ORACEL user exits. Page :

What is the User-Named Editor?

Description : What is the User-Named Editor?

Last Answer : A user named editor has the same text editing functionality as the default editor, but, because it is a named object, you can specify editor attributes such as windows display size, position, and title.

What is an user exit used for?

Description : What is an user exit used for?

Last Answer : A way in which to pass control (and possibly arguments ) form Oracle report to another Oracle products of 3 GL and then return control ( and ) back to Oracle reports.

How can I message to passed to the user from reports?

Description : How can I message to passed to the user from reports?

Last Answer : By using SRW.MESSAGE function. (Continued on next part...)