ALL,DBAuser的区别

Question

ALL_,DBA_user_的区别

Answer 1

SQL> create or replace type k as object(id int);
2 /
类型已创建.
SQL> create table m of k;
表已创建.
SQL> select table_name from dba_tables where table_name='M';
未选定行
SQL> select table_name from dba_all_tables where table_name='M';
TABLE_NAME
------------------------------
M