What is DDL, DML?

Thank for your work

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

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. 

Data Definition Language..

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

Data Manipulation Language..

   ->  Insert Command,Delete Command, Update Command

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....

     

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

 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

 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

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

dml means data manipulation language in which select is included.

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

DDL: CREATE, ALTER, TRUNCATE
DML: INSERT, UPDATE,DELETE and DROP

DDL is Data Definition Language.

DDL-Create, Alter, Drop.

DML is a Data Manipulation Language.

DML-Insert, Update, Delete.

DDL is data defination languages
DML is data manipulation languages

DDL=Data Definition Language (Create,Alter,Drop)
DML=Data Manipulation Language(Insert,Update,Merge)

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.

DDL = Data Definition Language
DML = Data Manipulation Language

DDL - Data Defination Language

DML - Data Manipulation Language

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

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.

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