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
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
Which is better Oracle or MS SQL? Why?
how to make an oracle object
Point out the difference between user tables and data dictionary?
How can Oracle users be audited?
How many types of tables supported by oracle?
Where are the settings stored for each instance in oracle?
What is a cognitive schema?
What are a query and state the different types of queries and their uses?
master table and child table performances and comparisons in Oracle ?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
What is the Tune Query
How to list all tables in your schema?
How to convert raw data type into text in oracle? Explain
What is the best way to do multi-row insert in oracle?