Skip to main content

Database Language | DDL | DML | DCL | TCL

Image
By

Database Language

Types of Database Language 

  1. Data definition language (DDL),
  2. Data manipulation language (DML),
  3. Data control language (DCL),
  4. Transaction control language (TCL),

Database Language

A DBMS has appropriate languages and interfaces to express database queries and updates.
Database languages can be used to read, store and update data in the database.

Types of Database Language

Database Language

1. Data Definition Language

  • DDL stands for Data Definition Language. It is used to define the database structure or pattern.
  • It is used to create schema, tables, indexes, constraints etc in the database.
  • Using DDL statements, you can create the skeleton of the database.
  • Data Definition Language is used to store the information of Meta data such as number of tables and schemas, their names, indexes, columns in each table, constraints, etc.

Here are some tasks that come under DDL:

  • Create: It is used to create objects in the database.
  • Alter: It is used to change the structure of the database.
  • Drop: It is used to delete objects from the database.
  • Truncate: It is used to extract all the records from a table.
  • Rename: It is used to rename an object
  • Comments: It is used to comment on the data dictionary.
These commands are used to update the database schema, so they come under Data definition language.

2. Data Manipulation Language

DML stands for Data Manipulation Language. It is used to access and manipulate data in the database.

Here are some tasks that come under DML:
  • Select: It is used to retrieve data from the database.
  • Insert: It is used to insert data into the table.
  • Select: It is used to retrieve data from the database.
  • Insert: It is used to insert data into the table.
  • Update: It is used to update the existing data within the table.
  • Delete: It is used to delete all the records from a table.
  • Merge: It performs UPSERT operations, which are insert or update operations.
  • Call: It is used to call a structured query language or Java subprogram.
  • Explain Plan: There is a parameter to explain the data in this
  • Lock Table: It Controls Concurrency

3. Data Control Language

DCL stands for Data Control Language It is used to retrieve stored or saved data.
The execution of DCL is transactional. It also has rollback parameters.
(But in Oracle database, there is no rolling facility in the execution of data control language.)

Here are some tasks that come under DCL:
  • Grant: It is used to grant user access privileges to a database.
  • Revoke: It is used to revoke permission from the user.
There are the following operations which have the authorization of Revoke:

CONNECT, INSERT, USAGE, EXECUTE, DELETE, UPDATE and SELECT.

4. Transaction Control Language

TCL is used to drive changes made by DML statements. TCLs can be grouped in a logical transaction.

Here are some tasks that come under TCL:
  • Commit: It is used to save the transaction on the database.
  • Rollback: This is used to restore the original database since the last commit.
Labels:

Comments

Post a Comment

Popular posts from this blog

Biography of Manohar Joshi

By
Biography of Manohar Joshi: Manohar Gajanan Joshi is an Indian politician who has played a significant role in Maharashtra state politics. Born on December 2, 1937, in a middle-class family in a village called Ganeshpeth in Ratnagiri district, Maharashtra, Joshi's journey into politics was marked by his association with the Shiv Sena, a right-wing regional political party in India. Joshi's political career began in the late 1960s when he joined the Shiv Sena, which was then led by its founder, Bal Thackeray. He quickly rose through the ranks of the party due to his organizational skills, dedication, and ideological alignment with the party's principles, which advocated for the interests of the Marathi-speaking population of Maharashtra. In 1972, Manohar Joshi won his first election to the Brihanmumbai Municipal Corporation (BMC), marking the beginning of his electoral career. He served as a corporator in the BMC and later became the Mayor of Mumbai in 1976. Joshi's tenu...
Post a Comment
Read more

Merry Christmas Messages and Statuses | History and Celebration Christmas - Happy Christmas Status and Messages for Social Media

By
Merry Christmas Messages and Statuses: Wishing you a Merry Christmas 2023! Here are some messages and statuses that you can share with your loved ones: "May your Christmas be filled with joy, laughter, and love. Wishing you a wonderful holiday season!". "Sending you warm wishes and good cheer this Christmas. Have a great time with your family and friends!". "May the spirit of Christmas fill your heart with peace and happiness. Merry Christmas!". "Wishing you a magical and blissful holiday season. Have a Merry Christmas and prosperous New Year!". "May this Christmas bring you all the love and luck in the world. Merry Christmas and a Happy New Year!". Wishing you a Merry Christmas 2023 Here are some Christmas messages that you can use to wish your friends and family a Merry Christmas: 1. Wishing you a Christmas filled with joy, love, and laughter. May the spirit of Christmas bring warmth to your heart and happiness to your home. 2. May y...
Post a Comment
Read more

Biography of Abbie Hoffman | Early Life and Political Activism - Later Years and Personal Life - Legacy of Abbie Hoffman

By
Biography of Abbie Hoffman: Abbie Hoffman (November 30, 1936 – April 12, 1989) was an American political and social activist known for his involvement in the counterculture and anti-war movements of the 1960s and 1970s. He was a key figure in the Youth International Party (Yippies) and was known for his theatrical and often humorous protests.  Here is a brief biography of Abbie Hoffman: Early Life of Abbie Hoffman: 1. Birth: Abbie Hoffman was born on November 30, 1936, in Worcester, Massachusetts, USA. 2. Education: He attended Brandeis University, where he earned a degree in psychology in 1959. Parada Kahanee Political Activism: 1. Civil Rights Movement: Hoffman began his activism by participating in the civil rights movement during the early 1960s. 2. Youth International Party (Yippies): In 1967, Hoffman, along with Jerry Rubin and others, co-founded the Yippies, a countercultural and anti-authoritarian political party known for its unconventional and theatrical protes...
Post a Comment
Read more