Difference Between Data Definition, Interactive Data Manipulation and Embedded Data Manipulation Language
Data Definition Language is a standard command that defines the different structures in a database. DDL statements create, modify, and remove database objects such as tables, indexes, and users. Common DDL statements are CREATE, ALTER, and DROP Interactive Data Manipulation Language uses SELECT statement, retrieving the data from a relational database, and INSERT, UPDATE and DELETE statements, that are used for data modification. Embedded SQL is a method of combining the computing power of programming language and the data manipulation capabilities of SQL. Embedded SQL statements are SQL statements written inline with the program source code, of the host language.