COMMIT Statement

The COMMIT statement explicitly makes everlasting changes to the database during the present transaction. The Changes made to the database are not considered everlasting until they are committed. The commit also makes the changes noticeable to the other users.

Syntax:

Keyword and Parameter Description

WORK:

This keyword is the optional and has no consequence except to improve the readability.

COMMENT:

These keywords specify a comment to be related with the present transaction and are typically used with the distributed transactions. The text should be a quoted literal no more than 50 characters long.

 

Posted Date: 10/6/2012 9:04:18 AM | Location : United States

Ask an Expert

Related Discussions:- Commit statement in pl sql, Assignment Help, Ask Question on Commit statement in pl sql, Get Answer, Expert's Help, Commit statement in pl sql Discussions

Write discussion on Commit statement in pl sql
Your posts are moderated

Write your message here..

Related Questions

Quantification in sql, Quantification in SQL To quantify something, as... Quantification in SQL To quantify something, as the theory book has it, is to state its quantity, to say how many of it there are. For example, in Tutorial D the expression CO

Identifiers in pl/sql, Identifiers You use identifiers to name the PL/S... Identifiers You use identifiers to name the PL/SQL program items and units that include constants, variables, cursors, exceptions, cursor variables, subprograms, and packages.

Biconditional - sql, Biconditional - SQL The biconditional p ↔ q can b... Biconditional - SQL The biconditional p ↔ q can be expressed in Tutorial D by p = q and the same is true of SQL. The question then arises as to whether, in SQL, p = q is equiv

Sql, Write a query to find academics that are authors and that have only ev... Write a query to find academics that are authors and that have only ever coauthored papers with authors from institutes in the same state as their own. List their academic number,

Difference between 9i & 10g, Difference between 9i & 10G When Oracle r... Difference between 9i & 10G When Oracle releases any new databases then it are having some discrepancy with them. But 10G is having much difference than oracle 9i has. Oracle

Effects of null for union - sql, Effects of NULL for union - SQL The ... Effects of NULL for union - SQL The treatment of NULL in invocations of EXCEPT is as for UNION. This is different from its treatment in those of NOT IN and quantified compari

Like operator-comparison operators, LIKE Operator You use the LIKE opera... LIKE Operator You use the LIKE operator to compare the character value to a pattern. The Case is significant. LIKE returns the Boolean value TRUE when the character patterns mat

Program, heap sort program in pl/sql heap sort program in pl/sql

Declaring objects in pl/sql, Declaring Objects: You can use the object ... Declaring Objects: You can use the object types wherever built-in types like CHAR or NUMBER can be used. In the block below, you can declare object r of type Rational. Then, yo

Develop data business intelligence project, Develop Data Business Intellige... Develop Data Business Intelligence Project Project Description: We are linking our Microsoft SQL Database to GoodData Business Intelligence. We are seeking somebody who has e