Commit statement in pl sql, PL-SQL Programming

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:

1917_commit statement.png

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







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
Related Questions
Use the NOCOPY Compiler Hint By default, the OUT and IN OUT parameters are passed by the value i.e. the value of an IN OUT actual parameter is copied into the corresponding fo

Pass the nulls to a dynamic SQL: Passing Nulls: Assume that you want to pass the nulls to a dynamic SQL statement. For illustration, you may write the EXECUTE IMMEDIATE

Implicit Cursor Attributes The Implicit cursor attributes returns the information about the execution of an INSERT, DELETE, UPDATE, or SELECT INTO statement. The cursor attribu

Explicit Cursors The set of rows returned by the query can include zero, one, or multiple rows, depending on how many rows meet your search criteria. Whenever a query returns

Effects of NULL The numeric variable X, perhaps of type INTEGER, might be assigned NULL. In that case the result of evaluating X + 1 is NULL, and so SET Y = X + 1 assigns NULL

Architecture The PL/SQL run-time system and compilation is a technology, not an independent product. Consider this technology as an engine that compiles and executes the PL/SQL

SELECT INTO Statement   The SELECT INTO statement retrieve data from one or more database tables, and then assigns the selected values to the variables or fields. Syntax:

THEORY OF BIOGENESIS - This theory explains that the existing living organisms originated from pre-existing living beings not from non living entities. This concept of or

Recursion The Recursion is a powerful method for simplify the design of the algorithms. Principally, the recursion means the self-reference. In the recursive mathematical serie

The accuracy of product table data is critical and the Brwebean's. owner wants to have an audit file that contains information regarding all DML activity on the BB_PRODUCT table. T