0
In Oracle, you can insert rows, update rows or delete rows from tables, but the changes are only current to your session. That means that if you insert a row in a table, no other users will be able to see it until you enter a COMMIT command. If you should enter or delete information by mistake, you have the chance to undo your changes by using the ROLLBACK command. The ROLLBACK will undo changes to data since the last COMMIT was executed.
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
What is commit and rollback?
They are both SQL statements used to either commit or undo data transactions. Wikipedia has a good general explanation (see links below) but depending on which database you use there may be different methods of handling transactions. Commit: http://en.wikipedia.org/wiki/Commit_%28data_management%29 Rollback: http://en.wikipedia.org/wiki/Rollback_%28data_management%29
What is the command to retrieve deleted data from any table in SQL?
rollback command can retrieve deleted data from a table, provided commit has not been performed after deleting the data. both rollback and commit are transaction control statements.
Can you use a commit statement within a database trigger?
Yes, you can very definitely use transactions within a trigger in one of two common ways; 1. As with any other use of transactions - to ensure a collection of commands within the trigger are executed in a repeatable way in the event of failure.2. To 'undo' the process that caused the trigger to fire. For example, the trigger might be doing some additional integrity checks and issuing a rollback to undo the initiating update/delete.---------AnswerCome to think of it, I have never seen a commit on triggers. Triggers as you know are a last line defense based on an action that was carried out by an insert,update or delete. Hence, since the trigger exists on the server, and is only fired if one of the above conditions are executed then it seems pointless to use a commit in the trigger. Also commit goes along nicely with transactions where you begin the transaction and if all is well then you issue a commit, else if the transaction fails, then you issue a rollback.
What are modules of oracle?
Oracle sells many functional modules which use the Oracle RDBMS as a back-end, notably Oracle Financials, Oracle HRMS, Oracle SCM, Oracle Projects, Oracle CRM, Oracle Procurement.
What is the meaning of rollback?
Rollback is lowering the price to an earlier price for an item.
Use the word oracle bone in a sentence?
The oracle bone was priceless.
When was Rollback - novel - created?
Rollback - novel - was created in 2007-04.
How many pages does Rollback - novel - have?
Rollback - novel - has 320 pages.
What an oracle?
"an oracle"An oracle is a person, such as priestess, through whom a deity is held to respond when consulted. An oracle is a being of great wisdom and insight. One from whom one would seek advice. A special priest guided by the Gods. "Oracle" Oracle Application Express, or Oracle Apex is an application one can use on the Oracle platform. It enables users to build web databases for use. There is no cost associated with the Oracle Apex.
What is the advantage of an oracle?
The advantage of an oracle is its ability to use the centralized management system.
What is an oracle?
"an oracle"An oracle is a person, such as priestess, through whom a deity is held to respond when consulted. An oracle is a being of great wisdom and insight. One from whom one would seek advice. A special priest guided by the Gods. "Oracle" Oracle Application Express, or Oracle Apex is an application one can use on the Oracle platform. It enables users to build web databases for use. There is no cost associated with the Oracle Apex.
Use the word oracle in a sentence?
The wise oracle predicted that I would win the Olympics.
