Search This Blog

Saturday, January 28, 2012

DQML

DQML Stands for Data Query and Manipluation Language
This is combination of DQL and DML
DQL:-
Data Query Language
Which is like:-
SQL>SELECT * FROM DUAL;
D
-
X
1 rows(s) selected


DML:-
Data Manipulation Language

INSERT
UPDATE
DELETE

as:-
INSERT INTO
VALUES(val1,val2.......valn);

UPDATE
SET col1=expr1,col2=expr2......coln=exprn
WHERE condition is true

DELETE
WHERE condition is true

DDL

DDL Stands for Data Definition Language

A few Examples for DDL are as follows:-
CREATE DATABASE
CREATE TABLE
CREATE VIEW
ALTER TABLE

SQL

SQL stands from Structured Query Language