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

What are few Oracle DDL statements or commands ?

Below are few  DDL commands to create, alter, drop, and rename tables. CREATE TABLE Create a table. Create a table based on another table by […]

Oracle 9i Tutorial : Naming Rule

Naming Rules : Table names and column names: Must begin with a letter Must be 1–30 characters long Must contain only A–Z, a–z, 0–9, _, […]

Oracle 9i Tutorial : Table and Data Dictionary

User Tables: –Are a collection of tables created and maintained by the user –Contain user information Data Dictionary: –Is a collection of tables created and […]

Leave a Reply