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 : 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 : CREATE TABLE Syntax

Oracle 9i Tutorial : CREATE TABLE Syntax •You must have: –CREATE TABLE privilege –A storage area •You specify: –Table name –Column name, column data type, […]

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

Leave a Reply

Discover more from Abhyas

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

Continue reading