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
Explain the use of file option in exp command.
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)
What is the difference between view and materialized view in Oracle?
What is PL/SQL ?
Can multiple columns be used in group by in oracle?
What is using clause and give example?
Explain the types of exception?
is there a tool to trace queries, like profiler for sql server?
What is a dynamic performance view in oracle?
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.
How can we delete duplicate rows in a table?
What is a partition in oracle?
What are the varoius components of physical database structure of oracle database?
What is a oracle database?
Why do you use stored procedures and state some of its disadvantages?