Oracle 9i Tutorial : Data Manipulation Language

      Data Manipulation Language ( DML )

A DML statement is executed when you:

–Add new rows to a table

–Modify existing rows in a table

–Remove existing rows from a table

Transaction

A transaction consists of a collection of DML statements that form a logical unit of work.

Related Posts

Oracle 9i Tutorial : Drop,Rename and Truncate table

DROP TABLE   Remove rows and a table structure.   Once executed, this statement cannot be rolled   back.   -DROP TABLE EMPLOYEE RENAME   […]

Oracle PL/SQL Quick Help : Developers

A PL/SQL Block consists of three sections: 1.The Declaration section (optional). 2.The Execution section (mandatory). 3.The Exception (or Error) Handling section (optional). Sample below : […]

Oracle 9i Tutorial : INSERT Statement Syntax

INSERT Statement Syntax INSERT statement is used to add new rows to table.Syntax of INSERT statement below : Only one row can be inserted at […]

Leave a Reply

Discover more from Abhyas

Subscribe now to keep reading and get access to the full archive.

Continue reading