Curso Oracle 11g - Lesson 3 - Programação Part2

--Lesson 3 - Tabelas de Sistema

Select *
from dictionary;

Select *
From user_tables;

Select *
From All_tables;

Select *
From dba_tables;

Select *
from user_objects
order by object_Type;

select * from user_indexes u
where u.index_name = 'SYS_C0011122';

select *
from user_tab_columns;

select *
from user_constraints;

select tab.table_name, null, com.comments, 1
from user_tables tab
      join user_tab_comments com on (tab.table_name = com.table_name)
union
select tab.table_name, col.column_name, com.comments, 2
from user_tables tab
            join user_tab_columns col on (tab.table_name = col.table_name)
            join user_col_comments com on (col.column_name = com.column_name
                                            and col.table_name = com.table_name);       



Fiquem a vontade para comentar e sugerir melhorias e/ou correção dos exemplos acima.