查询一个表的外键
select * from user_constraints where R_CONSTRAINT_NAME in (select constraint_name from user_constraints where table_name = 'STUDENT') ;
查看当前表的约束:
select table_name,constraint_name,constraint_type from user_constraints
where table_name='STUDENT';
查看当前表的索引:
select * from USER_INDEXES where table_name = 'CLASS'
查看当前用户下的序列:
select SEQUENCE_NAME from dba_sequences where SEQUENCE_OWNER=SCOTT;
查看当前用户下的视图:
select * from user_views;
给当前用户赋予操作表空间权限:
语法:alter user username quota umlimited on tablespacename;
ALTER USER SCOTT QUOTA UNLIMITED ON EXAMPLE;
给当前用户赋予创建视图权限:
grant create view to scott;
select * from user_constraints where R_CONSTRAINT_NAME in (select constraint_name from user_constraints where table_name = 'STUDENT') ;
查看当前表的约束:
select table_name,constraint_name,constraint_type from user_constraints
where table_name='STUDENT';
查看当前表的索引:
select * from USER_INDEXES where table_name = 'CLASS'
查看当前用户下的序列:
select SEQUENCE_NAME from dba_sequences where SEQUENCE_OWNER=SCOTT;
查看当前用户下的视图:
select * from user_views;
给当前用户赋予操作表空间权限:
语法:alter user username quota umlimited on tablespacename;
ALTER USER SCOTT QUOTA UNLIMITED ON EXAMPLE;
给当前用户赋予创建视图权限:
grant create view to scott;