The differences between them you can get from, http://arjudba.blogspot.com/2008/04/what-are-difference-between-ddl-dml-and.html
When a connection is created, it is in auto-commit mode. This means that each individual SQL statement is treated as a transaction and will be automatically committed right after it is executed. The way to allow two or more statements to be grouped into a transaction is to disable auto-commit mode
The basic difference between DDL and DML is the commands they provide . The DDL provides statement for the creation and deletion of tables, indexes, views etc. while the DML provides statements to enter, update, delete and perform complex queries on these tables.
The DDL provides statement for the creation and deletion of tables, indexes, views etc. The DML provides statements to enter, update, delete and perform complex queries on these tables.
DDL stands for Data Definition Language, and so it follows that creating a table is DDL, creating a view is DDL and so on.
The basic difference between DDL and DML is the commands they provide . The dml (data manipulation language) provides statements to enter, update, delete and perform complex queries on these tables while the ddl(data description language) provides statement for the creation and deletion of tables, indexes, views etc.
Full form of the DDL is Data Definition Language.
You can use COMMIT any time, but it is not necessary after TRUNCATE TABLE.
ddl stands for Data Definaton Language.Eg:- Create ,Alter .Drop.Truncate Why we have called it as DDL means.... we are defining or acting at structure level. Say, when ever you create a table we are dealing at strucutre level. Hence its is DDL
ddl: data definition languagedml: data manipulation language
The internal mission statement of the Volkswagen Auto Group is not available to the public. But in 2010 the company joined several other German auto makers in a collaborative mission statement entitled a "mission statement for responsible actions in business".
DDL compiler is the compiler whose job is to convert high level commands to low level commands..