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
%ISOPEN The %ISOPEN yields TRUE if its cursor or cursor variable is open; or else, the %ISOPEN yields FALSE. In the illustration, you use the %ISOPEN to select an action:

Subprograms The PL/SQL has two types of subprograms known as the procedures and functions that can take parameters and be invoked. As the following example represents, a subp

Read-Only Operator (+) - SQL The term read-only operator to the mathematical term function. Here I just need to add that the SQL standard reserves the term function for read-

Need Azure CRM Web Application with two-factor authentication We presently have a CRM-like database stored on MS Azure that we presently access over an MS Access application. It

Closest Approximation to Relational Union - SQL Actually, just as SQL has several varieties of JOIN, it also has several varieties of UNION, none of which is equivalent to th

Advantages of Invoker Rights The Invoker-rights routines centralize the data retrieval. They are particularly helpful in applications which store data in various schemas. In su

EXECUTE IMMEDIATE Statement   The EXECUTE IMMEDIATE statement prepare (parses) and instantly executes a dynamic SQL statement or an anonymous PL/SQL block. Syntax:

Use Native Dynamic SQL A few programs (a normal-purpose report writer for illustration) should build and process a variety of SQL statements at run time. Therefore, their full

Updating Variables For assignment, SQL uses the key word SET, as in SET X = X + 1 (read as "set X equal to X+1") rather than X: = X + 1 as found in many computer languages.

Literature review