2015管理表.pptVIP

外部表ext_department里面已经有数据了，我们就可以把这些数据导入到真正的Oracle的表中。 如：insert into department select * from ext_department; 可以使用user_external_tables来查看当前用户可以使用的外部表。 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 更改、删除外部表 修改默认目录对象 Create directory test_dir1 AS ‘E:\external1’; Alter table test_dept default directory test_dir1; 修改文件位置 Alter table ext_department location(’new.txt’); 修改访问参数 Alter table test_dept access parameters (fields terminated by ‘;’); 删除外部表 Drop table test_dept; 删除目录对象 Drop directory test_dir; Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. * 15.5 更改表 修改表 Alter table table_name Add column datatype[,…] |Modify (column datatype[,...]) |Drop column column_name |rename column column_name to newname 添加表和列注释 重命名表 和 重新组织表 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. * 添加列 Alter table department add ( leader varchar2(20), updateDate date default sysdate); 添加新列的时候，如果表中有记录了，那就不能直接指定Not Null约束。必须要有一个带Default子句的 Not Null约束。 Alter table department add ( note varchar2(40) default 备注 not null); Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. * 修改列 把department表的deptno字段改为char(6)、note字段改为varchar2(80) 。 Alter table department Modify ( deptno char(6), note varchar2(80) ); Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. * 删除列 单独删除一列： Alter table department drop column note cascade constraints; Alter table department drop (note) cascade constraints; 同时删除多列： Alter table department drop (updatedate,note) cascade constraints; Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011