Database - Explain DML and DDL statements

Explain DML and DDL statements.

Data definition language is used to define and manage all attributes and properties of a database.

Most DDL statements include following commands:

Data Manipulation Language: Data manipulation language is used to select, insert, update, and delete data in the objects defined with DDL.

Explain DML and DDL statements.

DDL-Data Definition Language: DDL is the syntax of SQL for defining the way the database is organized physically. Database meta data is created by DDL of SQL. The tables, views, indexes, sequences, triggers, database users (by DBA) are well defined using DDL statement, CREATE. Modification for the metadata or schema is done by ALTER command and removing database objects is done by DROP command.

DML-Data Manipulation Language: DML statements, INSERT, DELETE, UPDATE AND SELECT … INTO are used for data manipulation, adding new rows, deleting unwanted rows and changing data in the rows. These are known as SQL-change statements. DML does not change the schema of database.
Database - What is Union and Union All operator?
UNION is a set operator combines the relations of 2 or more select statements into one relation....
Database - What is cursor?
A cursor is a variable that represents an area where the result of a query is stored....
Database - Explain the cursor types
DYNAMIC, STATIC, KEYSET. Implicit Cursor and Explicit Cursor.......
Post your comment