View All Tables and fields and Table comments. Field comments in Oracle

View All Tables, fields, and Table comments in Oracle. Obtain the table with field comments: selecttable_namefromuser_tables; select Table owned by the current user

View All Tables, fields, and Table comments in Oracle. Obtain the table using field comments: select table_name from user_tables; // select Table owned by the current user

View All Tables and fields and Table comments. Field comments in Oracle

Get table:

Select table_name from user_tables; // The table owned by the current user

Select table_name from all_tables; // tables of all users
Select table_name from dba_tables; // includes the system table
Select table_name from dba_tables where owner = 'username'

User_tables:
Table_name, tablespace_name, last_analyzed, etc.
Dba_tables:
Ower, table_name, tablespace_name, last_analyzed, etc.
All_tables:
Ower, table_name, tablespace_name, last_analyzed, etc.
All_objects:
Ower, object_name, subobject_name, object_id, created, last_ddl_time, timestamp, status, etc.

Obtain table fields:

Select * from user_tab_columns where Table_Name = 'user table ';
Select * from all_tab_columns where Table_Name = 'user table ';
Select * from dba_tab_columns where Table_Name = 'user table ';
User_tab_columns:
Table_name, column_name, data_type, data_length, data_precision, data_scale, nullable, column_id, etc.
All_tab_columns:
Ower, table_name, column_name, data_type, data_length, data_precision, data_scale, nullable, column_id, etc.
Dba_tab_columns:
Ower, table_name, column_name, data_type, data_length, data_precision, data_scale, nullable, column_id, etc.

Get table comments:

Select * from user_tab_comments
User_tab_comments: table_name, table_type, comments
There are also dba_tab_comments and all_tab_comments, which have more ower columns than user_tab_comments.
Obtain field comments:
Select * from user_col_comments
User_col_comments: table_name, column_name, comments

Dba_col_comments, all_col_comments, which has more ower columns than user_col_comments.

--------------------------------------------------------------------------------

Installing Oracle 12C in Linux-6-64

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian

--------------------------------------------------------------------------------