OracleDDL,DML,DCL,TCL基础概念Oracle认证考试

文章作者 100test 发表时间 2010:03:07 15:12:21
来源 100Test.Com百考试题网


  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 - 0delete 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 - 0updates existing data within a table

  DELETE - 0deletes all records from a table, the space for the records remain

  MERGE - UPSERT operation (insert or 0update)


相关文章


查看锁住表的session并杀掉Oracle认证考试
ORACLE三表查询优化问题Oracle认证考试
什么是0型文法,1型文法,2型文法,3型文法Oracle认证考试
修改Oracle默认用户密码有效期时间Oracle认证考试
OracleDDL,DML,DCL,TCL基础概念Oracle认证考试
GATHER_STATS_JOB任务Oracle认证考试
ORACLE表空间设置问题Oracle认证考试
Oracle数据库ODU的几种恢复场景Oracle认证考试
Oracle数据库安全:PL_SQL的SQL注入Oracle认证考试
澳大利亚华人论坛
考好网
日本华人论坛
华人移民留学论坛
英国华人论坛