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

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

1 Answer

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.
by

Related questions

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.

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

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.

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

If an unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE ?

Description : If an unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE ?

Last Answer : It won't, Because SYSDATE format contains time attached with it.

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.

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

What is transactional trigger property?

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.

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 .

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 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.

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

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.

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.

. An important aim of a post-project review is to: a. validate overall progress to date against the budget and schedule. b. capture learning and document it for future usage. c. ensure acceptance of all permanent documentation, signed by the sponsor. d. establish that project benefits have been identified.

Description : . An important aim of a post-project review is to: a. validate overall progress to date against the budget and schedule. b. capture learning and document it for future usage. c. ... of all permanent documentation, signed by the sponsor. d. establish that project benefits have been identified.

Last Answer : b. capture learning and document it for future usage.

An important aim of a post-project review is to: a. validate overall progress to date against the budget and schedule. b. capture learning and document it for future usage. c. ensure acceptance of all permanent documentation, signed by the sponsor. d. establish that project benefits have been identified

Description : An important aim of a post-project review is to:  a. validate overall progress to date against the budget and schedule.  b. capture learning and document it for future usage.  c. ... of all permanent documentation, signed by the sponsor.  d. establish that project benefits have been identified

Last Answer : b. capture learning and document it for future usage.

What is the Difference between a post query and a pre query

Description : What is the Difference between a post query and a pre query

Last Answer : A post query will fire for every row that is fetched but the pre query will fire only once.

what are difference between post database commit and post-form commit?

Description : what are difference between post database commit and post-form commit?

Last Answer : Post-form commit fires once during the post and commit transactions process, after the database commit occurs. The post-form-commit trigger fires after inserts, updates and deletes have ... The post-database-commit trigger fires after oracle forms issues the commit to finalized transactions.

What is Post-Block is a. ???

Description : What is Post-Block is a. ???

Last Answer : a. Navigational Trigger. b. Key trigger c. Transaction Trigger.

Can a field be used in a report without it appearing in any data group?

Description : Can a field be used in a report without it appearing in any data group?

Last Answer : Yes

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 : 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?

Last Answer : Yes

There is a % sign in one field of a column. What will be the query to find it?

Description : There is a % sign in one field of a column. What will be the query to find it?

Last Answer : '' Should be used before '%'.

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.

.Can you attach an alert to a field?

Description : .Can you attach an alert to a field?

Last Answer : No

Can you attach an lov to a field at design time?

Description : Can you attach an lov to a field at design time?

Last Answer : Yes

Can you attach an lov to a field at run-time? if yes, give the build-in name.?

Description : Can you attach an lov to a field at run-time? if yes, give the build-in name.?

Last Answer : Yes. Set_item_proprety

List the system variables related in Block and Field?

Description : List the system variables related in Block and Field?

Last Answer : 1. System.block_status 2. System.current_block 3. System.current_field 4. System.current_value 5. System.cursor_block 6. System.cursor_field 7. System.field_status.

When one chooses a stance or takes a position don’t they always manage to find evidence to validate it?

Description : When one chooses a stance or takes a position don’t they always manage to find evidence to validate it?

Last Answer : Yes. Not all “evidence” is equal, though.

Why do some people directly misquote or manipulate what a person has said in order to validate their point?

Description : Why do some people directly misquote or manipulate what a person has said in order to validate their point?

Last Answer : answer:What do you mean by trouble making? Are you being racist?

What do you do when you have made a new friend who tellsyou that they have been hurt by people and they have trust issues and they make you feel as though you have to validate everything you say to them?

Description : What do you do when you have made a new friend who tellsyou that they have been hurt by people and they have trust issues and they make you feel as though you have to validate everything you say to them?

Last Answer : What about this friendship is valuable enough to give it more time?

Why do some websites put a "Validate XHTML/CSS" link on their external website?

Description : Why do some websites put a "Validate XHTML/CSS" link on their external website?

Last Answer : valid markup helps search engines for one, it is also to show you know how to properly code a website. So if you are a freelancer for example, and a small firm wants to outsource some work to you they can, without having to ask, see your site is built of proper, validated code.

“Industrialization and urbanisation go hand in hand.” Validate the statement. -SST 10th

Description : “Industrialization and urbanisation go hand in hand.” Validate the statement. -SST 10th

Last Answer : After an industrial activity starts in a town, urbanisation follows. Industry provides employment to the people of the area. Population migrates from rural hinterlands to seek jobs, Housing and ... financial advice, etc. to the industry. Thus, industrialisation and urbanisation go hand in hand.

In Britain the formation of the nation-state was not the result of a sudden upheaval or revolution. Validate the statement with relevant arguments. -SST 10th

Description : In Britain the formation of the nation-state was not the result of a sudden upheaval or revolution. Validate the statement with relevant arguments. -SST 10th

Last Answer : In Britain, the formation of the nation-state was not the result of a sudden upheaval or revolution. It was the result of a long-drawn-out process. Role of ethnic groups: their ... of Union 1707-between England and Scotland. The growth of the British identity. Language and religious policies.

Jute industry is concentrated in the Hugli basin'. Validate the statement with three suitable reasons. -SST 10th

Description : Jute industry is concentrated in the Hugli basin'. Validate the statement with three suitable reasons. -SST 10th

Last Answer : Various factors responsible for the concentration of the jute industry in the Hugli basin are - 1. The proximity of jute producing areas is a major factor along with the availability of ... as a large urban centre provides banking, insurance, and port facilities for export of jute goods.