What do the initials DDL and DML stand for and what is
their meaning?
Answer Posted / komal riaz
DDL(Data Definition Language) is used for the manipulation
of Tables in SQL. This involves three functions CREATE,ALTER
and DROP.
Whereas DML(Data Manipulation Language) is used for the
manipulation of data in the tables. This involves four basic
functions SELECT,INSERT,UPDATE,DELETE.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is dclgen (declaration generator)?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
Is ibm db2 free?
What is db2 stogroup?
What is multi row fetch in db2?
What are bind parameters in db2?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
Can we update view in db2?
How to create db2 table in mainframe?
How would you find out the total number of rows in a db2 table?
What is a db2 schema?
What is concurrency?
Is schema the same as database?
Which components manage deadlocks in db2?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.