带你认识oracle中的DDL、DML、DCL_Oracle数据库_黑客防线网安服务器维护基地--Powered by WWW.RONGSEN.COM.CN

带你认识oracle中的DDL、DML、DCL

作者:黑客防线网安Oracle维护基地 来源:黑客防线网安Oracle维护基地 浏览次数:0

本篇关键词:Oracle数据库Oracle教程
黑客防线网安网讯:    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...
    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
    黑客防线网安服务器维护方案本篇连接:http://www.rongsen.com.cn/show-13029-1.html
网站维护教程更新时间:2012-03-23 00:49:37  【打印此页】  【关闭
我要申请本站N点 | 黑客防线官网 |  
专业服务器维护及网站维护手工安全搭建环境,网站安全加固服务。黑客防线网安服务器维护基地招商进行中!QQ:29769479

footer  footer  footer  footer