Orcl1(data)教程.pptx

Data;Data Dictionary;;Data Dictionary;Data Dictionary Contents;How the Data Dictionary Is Used;Data Dictionary View Categories;Dynamic Performance Tables;Querying the Data Dictionary and Dynamic Performance Views;Data Dictionary Examples;Managing Tablespaces and Data Files;Overview;;SYSTEM and Non-SYSTEM Tablespaces;;Obtaining Tablespace Information;Tables;Storing User Data;;Character Data Types;Character Data Types;Character Data Types;Character Data Types;Numeric Data Types;Datetime and Interval Datatypes;Datetime and Interval Datatypes;日期格式元素;日期格式元素;日期格式元素;日期格式元素;Datetime and Interval Datatypes;Datetime and Interval Datatypes;Datetime and Interval Datatypes;Datetime and Interval Datatypes;大对象（LOB）型 ;Rowid型 ;Structure of a Row;Creating a Table;Changing Storage Parameters;Create a table and insert rows by combining the CREATE TABLE statement and the AS subquery option. Match the number of specified columns to the number of subquery columns. Define columns with column names and default values.;Creating Temporary Tables;Truncating a Table;Dropping a Table;Dropping a Column;Obtaining Table Information;Views; ;创建视图;创建视图; ; ; ; ;视图中使用DML的规定;视图中使用DML的规定;;使用 WITH CHECK OPTION 子句确保DML只能在特定的范围内执行 任何违反WITH CHECK OPTION 约束的请求都会失败;屏蔽 DML 操作; ; ;临时视图;Top-N 分析; ;实体化视图(MATERIAZED VIEW) ;实体化视图(MATERIAZED VIEW) ;刷新选项 ;实体化视图(MATERIAZED VIEW) ;相关数据字典