Difference between revisions of "Oracle:Data Manipulation Language"
From mi-linux
Jump to navigationJump to searchm (Protected "Oracle:Data Manipulation Language" ([Edit=Allow only administrators] (indefinite) [Move=Allow only administrators] (indefinite))) |
|
(No difference)
| |
Latest revision as of 15:54, 24 February 2016
Main Page >> Oracle and SQL >> Workbook >> Data Manipulation Language
Introduction
The SQL Lanuage is made up of three components:
- Data Manipulation Language (DML)
- Data Definition Language (DLL)
- Data Control Lanague (DCL)
This section will look at the DML Commands, which comprise of the following:
- SELECT: retrieves data from the tables
- INSERT: adds new rows of data to the tables
- DELETE: removes rows that are stored in the tables
- UPDATE: amends data that is stored in the tables
