Editing Data control language (section)

== Oracle Database ==
[[Oracle Database]] divide SQL commands to different types. They are.
* Data Definition Language (DDL) Statements
* Data Manipulation Language (DML) Statements
* Transaction Control Statements
* Session Control Statements
* System Control Statement
* Embedded SQL Statements

For details refer [https://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_1001.htm#SQLRF30001 Oracle-]<ref>{{Cite web|title=Database SQL Language Reference|url=https://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_1001.htm#SQLRF30001|access-date=2020-09-19|website=docs.oracle.com|language=en}}</ref>[https://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_1001.htm#SQLRF30001 TCL]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;

Data definition language (DDL) statements let you to perform these tasks:
* Create, alter, and drop schema objects
* Grant and revoke privileges and roles
* Analyze information on a table, index, or cluster
* Establish auditing options
* Add comments to the data dictionary

So Oracle Database DDL commands include the '''Grant''' and '''revoke''' privileges which is actually part of Data control Language in Microsoft SQL server.

Syntax for grant and revoke in Oracle Database:

=== Example ===
{{sxhl|2=sql|
GRANT SELECT, INSERT, UPDATE, DELETE ON db1.Employee TO user1;

REVOKE SELECT, INSERT, UPDATE, DELETE ON db1.Employee FROM user1;
}}

=== Transaction Control Statements in Oracle ===
Transaction control statements manage changes made by DML statements. The transaction control statements are:
* COMMIT
* ROLLBACK
* SAVEPOINT
* SET TRANSACTION
* SET CONSTRAINT