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.


1917_commit statement.png

Keyword and Parameter Description


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


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
Advantages of Subprograms The Subprograms give extensibility; that is, tailor the PL/SQL language to suit your requirements. For illustration, if you require a procedure which

Keyword and Parameter Description select_statement: This is a query which returns a result set of the rows. Its syntax is such that of select_ into_statement without the IN

Transaction context As the figure shows, the major transaction shares its context with the nested transactions, but not with the autonomous transactions. Similarly, If one aut

Using raise_application_error The Package DBMS_STANDARD that is supplied with Oracle gives language facilities that help your application to interact with Oracle. For illustra

V ariables and Constants in PL/SQL The PL/SQL permits you to declare constants and variables, and then use them in SQL and procedural statements anywhere in the expression. Th

SQL Cursor   The Oracle implicitly opens a cursor to process each SQL statement not related with an explicit cursor. The PL/SQL refers to the most current implicit cursor as t

Cursor Variables:   To execute the multi-row query, the Oracle opens an unnamed work region that stores the processing information. You can use an explicit cursor that names

Example of NOT EXISTS Operator - SQL Example is a translation into SQL of the corresponding example, which is included there merely to show that for any scalar comparison the

Raise_application_error -  procedure of package DBMS_STANDARD , allows to issue an user_defined error messages by stored sub-program or database trigger.

Bulk Fetching The illustration below shows that you can bulk-fetch from a cursor into one or more collections: DECLARE TYPE NameTab IS TABLE OF emp.ename%TYPE; TYPE S