Can you use a commit statement within a database trigger?

Can you use a commit statement within a database trigger?
by

1 Answer

Answer :

No
by

Related questions

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

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

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.

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

What will happen after commit statement ?

Description : What will happen after commit statement ?

Last Answer : Cursor C1 is Select empno, ename from emp; Begin open C1; loop Fetch C1 into eno.ename; Exit When C1 %notfound;----- commit; end loop; end; The cursor having query as SELECT .... FOR ... after COMMIT/ROLLBACK. The cursor having query as SELECT.... does not get closed even after COMMIT/ROLLBACK.

What is a 2 Phase Commit

Description : What is a 2 Phase Commit

Last Answer : Two Phase commit is used in distributed data base systems. This is useful to maintain the integrity of the database so that all the users see the same values. It contains DML statements or Remote ... b) Commit Phase :: Commit all participants to coordinator to Prepared, Read only or abort Reply

Describe two phases of Two-phase commit ?

Description : Describe two phases of Two-phase commit ?

Last Answer : Prepare phase - The global coordinator (initiating node) ask a participants to prepare (to promise to commit or rollback the transaction, even if there is a failure) Commit - Phase - If ... , if all participants cannot prepare, the coordinator asks all nodes to roll back the transaction.

What is Two-Phase Commit ?

Description : What is Two-Phase Commit ?

Last Answer : Two-phase commit is mechanism that guarantees a distributed transaction either commits on all involved nodes or rolls back on all involved nodes to maintain data consistency across the global distributed database. It has two phase, a Prepare Phase and a Commit Phase.

What does COMMIT do ?

Description : What does COMMIT do ?

Last Answer : COMMIT makes permanent the changes resulting from all SQL statements in the transaction. The changes made by the SQL statements of a transaction become visible to other user sessions transactions that start only after transaction is committed.

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

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

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

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

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.

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

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

In SQL, the CREATE TABLESPACE isused A. to createa place in the databasefor storageof scheme objects, rollback segments, andnaming the data files to comprise the tablespace B. to createa database trigger C. to add/rename data files, to change storage D. All of theabove E. None of the above

Description : In SQL, the CREATE TABLESPACE isused A. to createa place in the databasefor storageof scheme objects, rollback segments, andnaming the data files to comprise the tablespace B. to createa database trigger C. to add/rename data files, to change storage D. All of theabove E. None of the above

Last Answer : to createa place in the databasefor storageof scheme objects, rollback segments, andnaming the data files to comprise the tablespace

What is the advantage of a stored procedure over a database trigger ?

Description : What is the advantage of a stored procedure over a database trigger ?

Last Answer : We have control over the firing of a stored procedure but we have no control over the firing of a trigger.

What are the parts of a database trigger ?

Description : What are the parts of a database trigger ?

Last Answer : The parts of a trigger are: A triggering event or statement A trigger restriction A trigger action

Can U disable database trigger? How?

Description : Can U disable database trigger? How?

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

How will you force database to use particular rollback segment ?

Description : How will you force database to use particular rollback segment ?

Last Answer : SET TRANSACTION USE ROLLBACK SEGMENT rbs_name.

What database block size should I use? (for DBA)

Description : What database block size should I use? (for DBA)

Last Answer : Oracle recommends that your database block size match, or be multiples of your operating system block size. One can use smaller block sizes, but the performance cost is significant. Your choice should ... 8K. This is because volume manager products use 8K blocks (and this is not configurable).

What parameter will you use to force the starting of your database with a corrupted resetlog?

Description : What parameter will you use to force the starting of your database with a corrupted resetlog?

Last Answer : ALLOW_RESETLOGS_CORRUPTION

Is it possible to backup your database without the use of an RMAN database to store the catalog?

Description : Is it possible to backup your database without the use of an RMAN database to store the catalog?

Last Answer : Yes, but the catalog would be stored in the controlfile.

How does one manage Oracle database users? (for DBA

Description : How does one manage Oracle database users? (for DBA

Last Answer : Oracle user accounts can be locked, unlocked, forced to choose new passwords, etc. For example, all accounts except SYS and SYSTEM will be locked after creating an Oracle9iDB database using the DB ... locked users account ALTER USER scott PASSWORD EXPIRE; -- Force user to choose a new password

How does one manage Oracle database users? (for DBA

Description : How does one manage Oracle database users? (for DBA

Last Answer : Oracle user accounts can be locked, unlocked, forced to choose new passwords, etc. For example, all accounts except SYS and SYSTEM will be locked after creating an Oracle9iDB database using the ... from SYS.V$BH log buffer spaces Increase LOG_BUFFER parameter or move log files to faster disks

How does one backup a database using the export utility? (for DBA

Description : How does one backup a database using the export utility? (for DBA

Last Answer : Oracle exports are "logical" database backups (not physical) as they extract data and logical definitions from the database into a file. Other backup strategies normally back-up the physical data ... exports include more information about the database in the export file than user level exports.

What strategies are available for backing-up an Oracle database? (for DBA

Description : What strategies are available for backing-up an Oracle database? (for DBA

Last Answer : The following methods are valid for backing-up an Oracle database: Export/Import - Exports are "logical" database backups in that they extract logical definitions and data from the database to a file. ... , etc. If your database is in ARCGIVELOG mode, you also need to backup archived log files.

Why and when should I backup my database? (for DBA

Description : Why and when should I backup my database? (for DBA

Last Answer : Backup and recovery is one of the most important aspects of a DBAs job. If you lose your company's data, you could very well lose your job. Hardware and software can always be ... things that will get you. Most failed recoveries are a result of organizational errors and miscommunications.

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.