21 | Introduction to DML or Data Manipulation Language in SQL | Oracle PL/SQL Programming

DML stands for Data Manipulation Language.
It is a language used for selecting, inserting, deleting and updating data in a database.
It is used to retrieve and manipulate data in a relational database.
1. SELECT
2. INSERT
3. UPDATE
4. DELETE
DML performs read-only queries of data.
1. SELECT COMMAND
SELECT command is used to retrieve data from the database.
This command allows database users to retrieve the specific information they desire from an operational database.
It returns a result set of records from one or more tables.
SELECT Command has many optional clauses are as stated below:

Clause Description
WHERE It specifies which rows to retrieve.
GROUP BY It is used to arrange the data into groups.
HAVING It selects among the groups defined by the GROUP BY clause.
ORDER BY It specifies an order in which to return the rows.
AS It provides an alias which can be used to temporarily rename tables or columns.

2. INSERT COMMAND
INSERT command is used for inserting a data into a table.
Using this command, you can add one or more records to any single table in a database.
It is also used to add records to an existing code.

3. UPDATE COMMAND
UPDATE command is used to modify the records present in existing table.
This command updates existing data within a table.
It changes the data of one or more records in a table.

4. DELETE COMMAND
DELETE command is used to delete some or all records from the existing table.
It deletes all the records from a table.

21 | Introduction to DML or Data Manipulation Language in SQL | Oracle PL/SQL Programming

#DML_SQL #data_manipulation_language #insert_data #oracle_sql