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))) |
|||
| (2 intermediate revisions by the same user not shown) | |||
| Line 11: | Line 11: | ||
* [[Oracle:SELECT| SELECT: retrieves data from the tables]] | * [[Oracle:SELECT| SELECT: retrieves data from the tables]] | ||
* [[Oracle:INSERT|INSERT: adds new rows of data to the tables]] | * [[Oracle:INSERT|INSERT: adds new rows of data to the tables]] | ||
| + | * [[Oracle:DELETE|DELETE: removes rows that are stored in the tables]] | ||
* [[Oracle:UPDATE|UPDATE: amends data that is stored in the tables]] | * [[Oracle:UPDATE|UPDATE: amends data that is stored in the tables]] | ||
| − | + | ||
== Next Step == | == Next Step == | ||
[[Oracle:Data_Definition_Language|Data Defintion Language]]. | [[Oracle:Data_Definition_Language|Data Defintion Language]]. | ||
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
