DDL
Data Definition Language (DDL) statements are used to define the database structure or schema. Some examples:
CREATE - to create objects in the database
ALTER - alters the structure of the database
DROP - delete objects from the database
TRUNCATE - remove all records from a table, including all spaces allocated for the records are removed
COMMENT - add comments to the data dictionary
RENAME - rename an object
DML
Data Manipulation Language (DML) statements are used for managing data within schema objects. Some examples:
SELECT - retrieve data from the a database
INSERT - insert data into a table
UPDATE - updates existing data within a table
DELETE - deletes all records from a table, the space for the records remain
MERGE - UPSERT operation (insert or update)
CALL - call a PL/SQL or Java subprogram
EXPLAIN PLAN - explain access path to data
LOCK TABLE - control concurrency
DCL
Data Control Language (DCL) statements. Some examples:
GRANT - gives user's access privileges to database
REVOKE - withdraw access privileges given with the GRANT command
TCL
Transaction Control (TCL) statements are used to manage the changes made by DML statements. It allows statements to be grouped together into logical transactions.
COMMIT - save work done
SAVEPOINT - identify a point in a transaction to which you can later roll back
ROLLBACK - restore database to original since the last COMMIT
SET TRANSACTION - Change transaction options like isolation level and what rollback segment to use
分享到:
相关推荐
不全,只有三个 ANSI-ISO-IEC International Standard(IS) Database Language SQL Part 1 SQL...ANSI-ISO-IEC International Standard(IS) Database Language SQL Part 5 Host Language Bindings (SQL Bindings).pdf
ANSI/ISO/IEC International Standard(IS) Database Language SQL Part 5 Host Language Bindings (SQL Bindings)
ANSI/ISO/IEC International Standard(IS) Database Language SQL Part 4 Persistent Stored Modules (SQL Psm)
ANSI/ISO/IEC International Standard(IS) Database Language SQL Part 1 SQL/Framework
This section describes new features of Oracle Database 11g and provides pointers to additional information.
The primary tool required for implementing such applications is a database programming language, namely a formal language which is specialized in the definition and manipulation of relevant large-...
介绍Oracle预编译编程,其中包括Pro*C。 Intended Audience Anyone developing new applications or converting existing ...■The SQL database language ■Oracle database version 7 concepts and terminology
You'll get a crash course in data modeling, become familiar with SQLite's dialect of the SQL database language, and learn how you to work with SQLite using either a scripting language or a C-based ...
Database programming requires relatively little knowledge of C# but a lot of knowledge about relational database concepts and the database language SQL. This book assumes no prior database experience...
encountered this problem in our implementation of O11, which is a database language based on C11. O11 extends C11 with the ability to create and access persistent objects. In this paper, we describe ...
SQL, and Pro T-SQL 2012 Programmer's Guide provides the gateway to success in applying this increasingly important database language to everyday business and technical tasks. ☆ 出版信息:☆ [作者...
Oracle 11g R2 数据库的SQL语言指南,纯英文版。
Oracle Database PLSQL Language Reference 11g Release 2, 做Oracle PLSQL开发必备,有了此文档就不需要再找其他PLSQL文档了
2. A Functional Database Language for the Associative Model of Data Peter J .H. King. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .. 55 3. Scoped Referential...
Oracle Database SQL Language Quick Reference 11g Release 2 (11.2)
Oracle Database SQL Language Reference 11g Release 2 (11.2)-1634
This reference contains a complete description of the Structured Query Language (SQL) used to manage information in an Oracle Database. Oracle SQL is a superset of the American National Standards ...
BNF Grammar for ISO-IEC 9075-22003 - Database Language SQL (SQL-2003) SQL-Foundation BNF Grammar for ISO-IEC 90751992 - Database Language SQL (SQL-92) BNF Grammar for ISO-IEC 90751999 - Database ...
For these reasons, many languages, including the standard database language SQL, have long supported such relationships. However, there doesn’t seem to be any consensus in the community at large on ...