Common oracle and oracle languages

Source: Internet
Author: User

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.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.