oracle ocp笔记脚本齐全第七天les13_管理模式对象.pdfVIP

Managing Schema Objects 管理模式对象 Objectives 课程目标 After pleting this lesson, you should be able to do the following: 完成本课，你将学习到： • Add constraints 添加约束 • Create indexes 建立索引 • Create indexes by using the CREATE TABLE statement 使 用create table语句建立索引 • Create function-based indexes 建立基于函数的索引-FBI • Drop columns and set columns as UNUSED 删除不在使用 的列 • Perform FLASHBACK operations 执行flashback操作 • Create and use external tables 建立与使用外部表 2 - 2 Lesson Agenda 课程进度 • Using the A R TABLE statement to add, modify, and drop a column 使用a r table语句增加修改删除列 • Managing constraints: – Adding and dropping a constraint – Deferring constraints – Enabling and disabling a constraint • Creating indexes: – Using the CREATE TABLE statement – Creating function-based indexes – Removing an index • Performing flashback operations • Creating and using temporary tables • Creating and using external tables 2 - 3 A R TABLE Statement 修改表语句 Use the A R TABLE statement to:使用a r table语句能： • Add a new column 增加新的列 • Modify an existing column 修改存在的列 • Define a default value for the new column 定义默认值 • Drop a column 删除列 2 - 4 A R TABLE Statement 语法 Use the A R TABLE statement to add, modify, or drop columns: A R TABLE table ADD (column datatype [DEFAU xpr] [, column datatype]...); A R TABLE table MODIFY (column datatype [DEFAU xpr] [, column datatype]...); A R TABLE table DROP (column [, column] …); 2 - 5 Adding a Column 增加列 • You use the ADD clause to add co