Common oracle and oracle languages

Common oracle and oracle languages

In Oracle development, the client sends SQL statements to the server, the server compiles and executes SQL statements, and returns the execution results to the client.

An Oracle SQL statement consists of the following commands:
The alias Data Definition Language (DDL), including the CREATE Command, ALTER command, and DROP command.
Explain data manipulation language (DML), including the INSERT command, UPDATE command, DELETE command, SELECT... For update (query.
Explain Data Query Language (DQL), including basic query statements, Order By clauses, and Group By clauses.
The COMMIT transaction control language (TCL), including the COMMIT command, SAVEPOINT command, and ROLLBACK command.
REVOKE Data Control Language (DCL), GRANT (authorization) command, and REVOKE (revocation) command.

Currently, mainstream database products (such as SQL Server and Oracle) support standard SQL statements.
Data Definition Language, table addition, deletion, modification, simple data query, transaction commit and rollback, permission authorization and revocation, and so on. Oracle and SQL Server are basically the same in terms of operations.