Difference between revisions of "Oracle:Data Manipulation Language"
From mi-linux
Jump to navigationJump to search (Created page with "Main Page >> Oracle and SQL >> Workbook >> Data Manipulation Language == Introduction == The SQL Lanuage is made up of three components: *...") |
|||
| Line 16: | Line 16: | ||
== Next Step == | == Next Step == | ||
| − | [[Oracle:Data_Definition_Language | + | [[Oracle:Data_Definition_Language|Data Defintion Language]]. |
Revision as of 15:22, 19 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
- UPDATE: amends data that is stored in the tables
- DELETE: removes rows that are stored in the tables
