SQL is a standard Query language for storing, manipulating and retrieving data in databases.
SQL provides statements for a variety of tasks, including:
-Inserting, updating, and deleting rows in a table
-Creating, replacing, altering, and dropping objects
-Controlling access to the database and its objects
-Guaranteeing database consistency and integrity
Our SQL tutorial will teach you how to use SQL in: Oracle database systems.
Data Manipulation Language (DML):
Fetching data from a database, add new rows, changes existing rows, delete an unwanted row from tables in the databases, respectively. known as Data Manipulation languages (DML)
Data Definition Language (DDL):
Sets up, changes and removes data structures from tables, known as
data definition languages (DDL)
Data Control Language (DCL):
Provides or removes access rights to Oracle Database
Data Transaction Control (DTC) :
Manages the changes made by DML Statements. Changes to the data can be grouped together into logical transactions.