What is DDL, DML?

  • Interview Candidate
  • 38
  • 19683

  
Showing Answers 1 - 38 of 38 Answers

arun

  • May 31st, 2005
 

Thank for your work

  Was this answer useful?  Yes

sangeeta

  • Jun 1st, 2005
 

ddl-data defination language  
create ,alter,drop 
dml-data manipulation language 
insert,update, delete,select

  Was this answer useful?  Yes

Ravi Prakash Pichika

  • Jun 20th, 2005
 

The SQL sentences that are used to create objects are called DDL's or Data Definition Language. 
 
The SQL sentences used to manipulate data within these objects are called DML's Data Manipulation Language. 

Hemanth

  • Sep 14th, 2005
 

Data Definition Language..

   ->  Create Command, Drop Command, Alter Command and Truncate Command

Data Manipulation Language..

   ->  Insert Command,Delete Command, Update Command

  Was this answer useful?  Yes

bhawesh

  • Feb 21st, 2006
 

ddl cmd are to define structure of a database object (like: table).

DDL->data defination language.

eg: Creating a new table.

      Droping a table,Altering its structure

dml cmds are usd to work on data stored in table

DML-> data manipulation language

eg: updating existing record.

      deleting and inserting records and so on....

     

  Was this answer useful?  Yes

Biplab Kabi

  • Mar 23rd, 2006
 

DDL is Data Definition Language statements. 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 ? GRANT - gives user's access privileges to database ? REVOKE - withdraw access privileges given with the GRANT command DML is Data Manipulation Language statements. 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 ? CALL - call a PL/SQL or Java subprogram ? EXPLAIN PLAN - explain access path to data ? LOCK TABLE - control concurrency

  Was this answer useful?  Yes

Ashfaq

  • Apr 9th, 2006
 

 DDL :- This is the language provided by Oracle ( Data defination Language )

its having four commands

 Create , Alter , Delete , Truncate

DML :- Data manuplation language (DML)

 Insert , Update , Delete , select

                                      thanks

  Was this answer useful?  Yes

Ashfaq

  • Apr 9th, 2006
 

 DDL :- This is the language provided by Oracle ( Data defination Language )

its having four commands

 Create , Alter , drop , Truncate

DML :- Data manuplation language (DML)

 Insert , Update , Delete , select

                                      thanks

  Was this answer useful?  Yes

vaishali

  • Apr 17th, 2006
 

ddl means data definatination language. in which create table table name is included.while

dml means data manipulation language in which select is included.

  Was this answer useful?  Yes

Raj Kumar Singh

  • May 1st, 2006
 

Hi

Friends

  DDl is a data definition language.DDL Define the data Structure and what are the size of actual data.

The following perform by DDL

  1. Create
  2. Alter table
  3. Drop Table

DML works are.

  1. Select
  2. update
  3. insert into
  4. delete

  Was this answer useful?  Yes

Mohammed Abdul Afroze

  • Sep 20th, 2007
 

DDL is Data Definition Language.

DDL-Create, Alter, Drop.

DML is a Data Manipulation Language.

DML-Insert, Update, Delete.

junaid badar

  • Dec 12th, 2009
 

In DDL  we can change the structure of the table using ALTER, DROP commands and in DML we can maniputlate data in the table using INSERT, SELECT, DELETE etc.

  Was this answer useful?  Yes

latif Zafarzai

  • Aug 16th, 2011
 

Data Definition Language (DDL) statements are used to define the database structure or schema. Some examples:
o CREATE - to create objects in the database
o ALTER - alters the structure of the database
o DROP - delete objects from the database
o TRUNCATE - remove all records from a table, including all spaces allocated for the records are removed
o COMMENT - add comments to the data dictionary
o RENAME - rename an object

  Was this answer useful?  Yes

Venki

  • Dec 19th, 2011
 

DDL means "Data Definition Language". SELECT, UPDATE, INSERT belong to DML, which is "Data Modification Language". DDL is all the other commands -- for example, CREATE TABLE.

  Was this answer useful?  Yes

SHIMAR

  • Apr 16th, 2012
 

DDL is used to create, alter and truncate
DML is used to insert, update, delete and drop

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.