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
No comments:
Post a Comment