Oracle SQL divided SQL statements in to various categories

1. Data definition language (DDL)
This statement are use to define, alter, or drop data base object.

Eg: CREATE TABLE, ALTER TABLE.




2. Data Manipulation Language (DML)

This statement are use to access create or manipulate data in the data base.


Eg :
SELECT, UPDATE, INSERT, DELETE

3. Transaction Control Language
This is to manage the changes made by the DML statement, whether to same discard.

Eg :
COMMIT, ROLEBACK

ROLEBACK to save point

No comments:

Post a Comment

Hi thank you for comment in Assignment Lanka " Book Mark on me' To future references.

Note: Only a member of this blog may post a comment.

Temporary

" Temporary " means that every project has a definite beginning and a definite end. The end is reached when the project's ob...

Assignment Lanka Populer Posts ever