Oracle Base
来源:互联网 发布:mac战地2 编辑:程序博客网 时间:2024/06/04 18:19
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
- Oracle-Base
- Oracle Base
- oracle base funny sql
- oracle base one
- base
- Base
- BASE
- base-``
- base
- Base
- base
- base
- Base
- Oracle Uninstall [from http://www.oracle-base.com/articles/misc/ManualOracleUninstall.php]
- CentOS安装Oracle教训之[INS-32015] The location specified for Oracle Base is invalid.
- 安装gc时遇到"Please specify a Unique Oracle Base directory ..."错误
- INS-32026]The Software Location specified should not be under Oracle base location.
- Base-X;Base-T;Base-TX;解释
- 一、类的声明和实现
- Oracle 迭代查询
- Shell SED 使用
- Android屏幕自适应
- VTK修炼之道79:交互与拾取_单位拾取
- Oracle Base
- Oracle Log Type
- Oracle Archive and Noarchive
- Python Mail
- Python Time
- c中的string
- Python & Excel
- Oracle Time
- 万能地图下载器中授权谷歌卫星地图下载器的方法