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

Answer Posted / vikranth

sql is a structured query language which acts as an
interface to the RDBMS.It is used in the application
development side to select the data from the database.

DDL is Data definition language statements which are used
to develop a structure to the table. where as DML(data
manipulation language statements) are used to perform the
updations to the data.

Is This Answer Correct ?    77 Yes 33 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the use of file option in exp command.

587


i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

1797


What is the difference between view and materialized view in Oracle?

593


What is PL/SQL ?

1098


Can multiple columns be used in group by in oracle?

533






What is using clause and give example?

575


Explain the types of exception?

636


is there a tool to trace queries, like profiler for sql server?

583


What is a dynamic performance view in oracle?

590


Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1496


How can we delete duplicate rows in a table?

552


What is a partition in oracle?

534


What are the varoius components of physical database structure of oracle database?

555


What is a oracle database?

594


Why do you use stored procedures and state some of its disadvantages?

552