What are the difference between DDL and DML?

Author Topic: What are the difference between DDL and DML?  (Read 5193 times)

Offline Die HardTopic starter

  • Trade Count: (0)
  • Jr. Member
  • **
  • Thank You 5
  • Posts: 65
  • Karma: 0
  • Gender: Male
  • No body perfect in this world, I m no body.!
    • Pics Door
What are the difference between DDL and DML?
« on: 01-16-2013, 06:09:48 »
What are the difference between DDL and DML? And why and where should we use these term in SQL?


Offline Luca tall

  • Trade Count: (0)
  • Jr. Member
  • **
  • Thank You 3
  • Posts: 53
  • Karma: 0
  • Gender: Male
    • PHP Training in Chennai
Re: What are the difference between DDL and DML?
« Reply #1 on: 04-26-2013, 00:59:15 »
DDL statemants are used to define the data structure or schema for example TRUNCATE,ALTER,DROP and CREATE.
DML statements are used for managing the data withion schema objects for example SELECT,INSERT,UPDATE,DELETE,MERGE,CALL,EXPLAIN PLAN and LOCK TABLE.

Offline keith.bowman

  • Trade Count: (0)
  • Semi-Newbie
  • *
  • Thank You 0
  • Posts: 10
  • Karma: 0
  • Gender: Male
Re: What are the difference between DDL and DML?
« Reply #2 on: 10-29-2014, 06:17:42 »
DDL stands for data definition language which is often used to define the database structure or schema. On the other hand, DML stands for Data Manipulation Language which is often used for managing data within schema objects.
Asuem Infotech [nofollow]

Offline AlfredBellemare

  • Trade Count: (0)
  • Newbie
  • *
  • Thank You 0
  • Posts: 1
  • Karma: 0
Re: What are the difference between DDL and DML?
« Reply #3 on: 02-14-2015, 03:39:21 »
DDL: Data Definition Language (DDL) statements are used to define the database structure or schema. Some examples:

    CREATE - to create objects in the database
    ALTER - alters the structure of the database
    DROP - delete objects from the database
    TRUNCATE - remove all records from a table, including all spaces allocated for the records are removed
    COMMENT - add comments to the data dictionary
    RENAME - rename an object

DML: Data Manipulation Language (DML) statements are used for managing data within schema objects. Some examples:

    SELECT - retrieve data from the a database
    INSERT - insert data into a table
    UPDATE - updates existing data within a table
    DELETE - deletes all records from a table, the space for the records remain
    MERGE - UPSERT operation (insert or update)
    CALL - call a PL/SQL or Java subprogram
    EXPLAIN PLAN - explain access path to data
    LOCK TABLE - control concurrency

Offline Ghazala

  • Trade Count: (0)
  • Jr. Member
  • **
  • Thank You 1
  • Posts: 60
  • Karma: 0
Re: What are the difference between DDL and DML?
« Reply #4 on: 03-09-2016, 22:09:22 »
Hello Friends,

Data Manipulation Language (also known as DML) is a family of computer languages. They are used by computer programs, and/or database users, to manipulate data in a database – that is, insert, delete and update this data in the database.

Data Definition Language (also known as DDL) is a computer language used to define data structures – as its namesake suggests. It first made its appearance in the CODASYL database model (a model pertaining to the information technology industry consortium, known as Conference on Data Systems Languages).

Thanks


Offline TomClarke

  • Trade Count: (0)
  • Hero Member
  • *****
  • Thank You 44
  • Posts: 893
  • Karma: 0
  • Gender: Male
    • Custom Writing Service & Content Marketplace
Re: What are the difference between DDL and DML?
« Reply #5 on: 04-19-2016, 00:25:36 »
DDL and DML are two types of Database Languages. They are called sub-languages, as they have fewer facilities than full-fledged programming languages.
DDL stands for Data Definition Language, and mainly used to define the schema  within a database. It also defimes the relationship between the entries within the database. DML stands for Data Manipulation Language and also a Database Language. And unlike DDL, DML can be utilized to insert, delete, revive and modify the data, rather than just specify it. 
 
Your ideas, our writings - Writology.com

 

Related Topics

  Subject / Started by Replies Last post
23 Replies
5379 Views
Last post 02-04-2012, 13:06:47
by dany
6 Replies
2571 Views
Last post 10-24-2011, 00:30:13
by Hogward
22 Replies
10487 Views
Last post 12-04-2016, 23:34:48
by annarichart
34 Replies
17153 Views
Last post 03-25-2014, 06:13:10
by parijatziw
22 Replies
7344 Views
Last post 12-18-2016, 20:20:43
by LaurentHector