数据字典总结(Oracle 10g)
Oracle data dictionary
1 To see some kind of fields belong to some table
--查看字段中含有”A”并且所有者是”Test”的表
SQL>select table_name from dba_tab_cols where column_name='A' and owner='TEST';
2 rename a table to a new one
--重命名表名
SQL>rename oldtablename to newtablename
3 modify a field,changing its data type.Datum empty needed first. --修改字段的类型
SQL>alter table testtable modify id varchar2(12)
4 rename a column of a table to a new one
--重命名字段名
SQL>alter table testtable rename column id to iden;
5 delete a column form a table
--删除字段
SQL>alter table testtable drop column id;
6 add a new field to a table
--添加字段
SQL>alter table testtable add newfield varchar2(2);
7 To view privileges or roles one user own
--查看当前用户下的表权限
SQL>select * from user_tab_privs;
…… …… 余下全文