What is the difference between SQL, DDL, and DML?
Answer Posted / animesh
SQL IS A STRUCTURED QUERY LANGUAGE THROUGH WHICH WE CAN
COMMUNICATE WITH THE ORACLE SERVER AND SQL STATEMENTS ARE
DIVIDED INTO FIVE STATEMENTS i:e. Data defintion language
(DDL) which is used in creating the tables,views. In DDL
create,
Alter,
Drop,
Rename,
Trucate comes.
where as Data Manipulation Language(DML)command is used to
manipulate the data.In DML
Insert,
Update,
Delete,
Merge.
the third one is Data retrieval i:e. the select command
the fourth one is Transcation control i:e.
commit,Rollback,savepoint.
the fifth one is data control language(DCL) i:e.
grant,revoke
Is This Answer Correct ? | 53 Yes | 15 No |
Post New Answer View All Answers
State and explain about oracle instance?
Explain the difference between sap and oracle?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What is oracle update statement with inner join ?
What are the execution control statements?
What is a database schema in oracle?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
What is a nvl function? How can it be used?
How to insert a new row into a table in oracle?
What are transaction isolation levels supported by oracle?
What is open database communication (odbc) in oracle?
How oracle handles dead locks?
How to create a new view in oracle?
What is an oracle table?
What is index-organized table in Oracle?