Four types of SQL language and Oracle operators

There are four types of SQL statements:
Data definition language (DDL)
Data manipulation Language (DML)
Data Control Language (DCL)
Transaction Control Language (TCL)

Data Definition Language (DDL)
DDL gives us the ability to create or delete tables. You can also define indexes (keys), specify links between tables, and impose constraints between tables.

Create database-Creating new databases
ALTER DATABASE-Modify databases
CREATE table-Creates a new table
ALTER TABLE-Change (change) database table
drop table-Delete tables
Create index-Creating indexes (search key)
Drop INDEX-Delete indexes

Data manipulation Language (DML)
for users to implement the data append, delete, update, query and other operations.

SELECT-Get data from a database table
Update-updating data in a database table
Delete-Deletes data from the database table
INSERT into-inserts data into a database table

Data Control Language (DCL)

Grant-Authorization
REVOKE-Revoke Authorization
Deny-Deny authorization

Transaction Control Language (TCL)

SavePoint-Set Save point
ROLLBACK-Rollback
Commit-Commit

Oracle operator

Expressions are similar to Java, can be constants, can be variables, or they can be a field in a table

Arithmetic operators (+-*/)
Comparison operators (> >= < <= = <>/!=)
logical operators (and or not)

Four types of SQL language and Oracle operators