Difference between revisions of "Transaction Control Statement"
Jump to navigation
Jump to search
(Created page with "==Commit Command == '''A COMMIT command issued implicitly or explicitly permanently saves the DML statements issued previously''' *An explicit COMMIT occurs when you enter a C...") |
|||
| Line 2: | Line 2: | ||
'''A COMMIT command issued implicitly or explicitly permanently saves the DML statements issued previously''' | '''A COMMIT command issued implicitly or explicitly permanently saves the DML statements issued previously''' | ||
*An explicit COMMIT occurs when you enter a COMMIT statement | *An explicit COMMIT occurs when you enter a COMMIT statement | ||
* an implicit COMMIT occurs when you exit client tools, such as SQL Developer. It also occurs if a DDL command, such as CREATE or ALTER TABLE, is issued. In other words, if a user adds several records to a table and then creates a new | * an implicit COMMIT occurs when you exit client tools, such as SQL Developer. It also occurs if a DDL command, such as CREATE or ALTER TABLE, is issued. In other words, if a user adds several records to a table and then creates a new table, the records added before the DDL command is issued are committed automatically (implicitly). | ||
table, the records added before the DDL command is issued are committed automatically (implicitly). | |||
Revision as of 20:22, 18 October 2017
Commit Command
A COMMIT command issued implicitly or explicitly permanently saves the DML statements issued previously
- An explicit COMMIT occurs when you enter a COMMIT statement
- an implicit COMMIT occurs when you exit client tools, such as SQL Developer. It also occurs if a DDL command, such as CREATE or ALTER TABLE, is issued. In other words, if a user adds several records to a table and then creates a new table, the records added before the DDL command is issued are committed automatically (implicitly).