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 : Adding Comments to Table

Adding a Comment to a Table You can add a comment of up to 2,000 bytes about a column, table, view, or snapshot by using […]

Oracle 9i Tutorial : UPDATE Statement Syntax

UPDATE Statement Syntax Update Statement is used to modify existing rows in table. Below is Update State Syntax : UPDATE  table SET  column = value […]

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, _, […]

Leave a Reply

Discover more from Abhyas

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

Continue reading