Get Started

Introduction to DBMS

SQL COMMANDS

Rollback Command

Savepoint Command

CONSTRAINTS

NOT NULL

SQL FUNCTIONS

STRING FUNCTION

NUMERIC FUNCTION

PL/SQL

ADVANTAGES OF PL/SQL

DATATYPES AND DECLARATION

VARIABLES AND CONSTANTS

CONTROL STATEMENTS

ITERAIVE CONTROL

CONDITIONAL CONTROL

ERROR HANDLING

OVERVIEW OF ERROR HANDLING

EXCEPTION TYPES

DATATYPES AND DECLARATION

SUBPROGRAMS

INTRODUCTION

DATABASE TRIGGERS

ERROR WITH TRIGGERS

COMMIT Command

The COMMIT Command:

The COMMIT command is the transactional command used to save changes invoked by a transaction to the database.

The COMMIT command is the transactional command used to save changes invoked by a transaction to the database. The COMMIT command saves all the transactions to the database since the last COMMIT or ROLLBACK command.

The syntax for the COMMIT command is as follows.


COMMIT;