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
Example of ADD CONSTRAINT in SQL Example: Alternative formulation for MAX_ENROLMENTS ALTER TABLE IS_ENROLLED_ON ADD CONSTRAINT MAX_ENROLMENTS CHECK ((SELECT COUNT (*)

Using Cursor Attributes: Every cursor has 4 attributes: %NOTFOUND, %FOUND, %ISOPEN, and %ROWCOUNT. If appended to the cursor name, they return the helpful information about

Authorize and fetch data from Instagram Project Description: Incorporate Instagram feed on mobile site platform: c#, ms sql, jquerymobile, jquery Web admin Author

Parameter Aliasing   To optimize the subprogram call, the PL/SQL compiler can decide between the two techniques of the parameter passing. With the by-value techniques, the v

Many of the reports generated from the system calculate the total dollars in purchases for a shopper. Complete the following steps to create a function named TOT_PURCH_SF that acce

Use of Table Expressions - Expressing Constraint Conditions With the exception of key constraints, the examples in the theory book all explicitly reference at least one relvar

Parameter and Keyword Description: cursor_name: This identifies an explicit cursor formerly declared within the present scope. cursor_variable_name: These identif

Inner Join We have learned how to retrieve data from one table by using SELECT statement. But, as we have learned, normalized relational databases mean the data is spread betw

Advantages of PL/SQL The PL/SQL is a high-performance transaction processing, completely portable language that offers the following advantages as shown: 1) Support for SQL

Multiset types - SQL An SQL multiset is what in mathematics is also known as a bag-something like a set except that the same element can appear more than once. The body of an