Difference between revisions of "Oracle:Data Manipulation Language"
From mi-linux
Jump to navigationJump to search| 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: | + | * [[Oracle:DELETE|DELETE: removes rows that are stored in the tables]]* [[Oracle:UPDATE|UPDATE: amends data that is stored in the tables]] |
| − | * [[Oracle: | + | |
== Next Step == | == Next Step == | ||
[[Oracle:Data_Definition_Language|Data Defintion Language]]. | [[Oracle:Data_Definition_Language|Data Defintion Language]]. | ||
Revision as of 17:00, 22 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
