a) How to know table Owner
select * from all_tables t where t.table_name = 'XXXX';
(select * from user_tables t where t.table_name = 'XXXX';)
b) How to use source fragment to find source name
select * from user_source t where lower(t.text) like '%xxx%';
select * from all_source t where lower(t.text) like '%xxx%';
Note: user_source: name, type(PACKAGE,PACKAGE BODY), line, text:varchar2(4000)
c) How to find object information
select * from user_objects;
select * from all_objects;
d) How to find constrains
select * from user_constraints;
e) Column, etc
select * from user_tab_cols; --get each column properties
select * from user_col_comments t where lower(column_name) LIKE '%xxx%';
f) How to check Oracle version
select * from v$version;