What is the difference between SQL, DDL, and DML?

Answer Posted / pavan_1981

sql is a universally accepeted query language whic acts an
interface to the relational databases to fetch,insert and
manipulate the data existing in the database.
sql encompasses of five parts
1.Data Retrieval Language:the commands used to select data
from the database.this includes
a.select
2.Data manipulation Language:commands to manipulate the
data existing in the database.commands in this are
a.insert
b.update
c.delete
d.merge
3.Data Definition Language:commands to define and create
the database ojects like tables ,views etc.commands in this
are
a.create
b.truncate
c.alter
d.drop
e.describe
f.rename
4.Tranaction control Language:the commands in this are
a.grant
b.revoke
5.Data Control Language:the commands in this are
a.Commit
b.Rollback
c.Savepoint.

Is This Answer Correct ?    113 Yes 25 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

3822


How to revoke create session privilege from a user in oracle?

538


How do I start tns listener?

512


Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1782


How to store only time; not date and time?

538






How to create a table index?

538


Can we create database in oracle using command line ?

556


What are the arithmetic operations?

560


I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

1815


What happens if you lost a data file?

551


What are the various types of snapshots ?

539


Why oracle is used?

557


How to assign values to data fields in record variables?

553


Where do we use decode and case statements?

528


How to speed up webrick?

568