Oracle displays the user's table names, Table Comments, field names, field comments, whether it is empty, field type, and oracle fields.

Oracle displays the user's table names, Table Comments, field names, field comments, whether it is empty, field type, and oracle fields.

-- Oracle: view all the table names, Table Comments, field names, field comments of the user, whether the table is empty, and select distinct TABLE_COLUMN of the field type. *, TABLE_NALLABLE.DATA_TYPE, TABLE_NALLABLE.NULLABLE from (select distinct utc. table_name, utc. comments table_comments, ucc. column_name, ucc. comments column_comments from user_tab_comments utc, user_col_comments ucc where utc. table_name = ucc. table_name and utc. table_name not like '% _ B' and utc. table_name not like '% _ Z' and utc. table_name not like '% 1%') TABLE_COLUMN, (select distinct table_name, column_name, nullable, DATA_TYPE from user_tab_cols where table_name not like '% _ B' and table_name not like '% _ Z' and table_name not like' % 100 ') TABLE_NALLABLE where TABLE_COLUMN.column_name = tables and TABLE_COLUMN.TABLE_NAME = TABLE_NALLABLE.table_name -- and TABLE_COLUMN.column_comments like '% category name %' and category like '% dictionary %'; -- remove Cartesian multiple times

How can I query the field types, field comments, and field names in an oracle table?

You can use the following statement:
SELECT B. column_name -- field name
, B. data_type -- field type
, B. data_length -- Field Length
, A. comments -- field comment
FROM user_col_comments
, All_tab_columns B
WHERE a. table_name = B. table_name and
A. table_name = 'table _ name ';

PS:
Table_name is case sensitive.

Query all the field names in the table with known table names in oracle. Check whether each field is a primary key, a foreign key, or an empty SQL statement,

Query all the columns and their attributes of a table:
Select t. *, c. COMMENTS
From user_tab_columns t, user_col_comments c
Where t. table_name = c. table_name and t. column_name = c. column_name and t. table_name = women;
Query the table's primary key:
Select cu .*
From user_cons_columns cu, user_constraints au
Where cu. constraint_name = au. constraint_name and au. constraint_type = 'p' and au. table_name = women;
Search for the table's foreign key (including the name, referenced table name, and corresponding key name. The following is a multi-step query ):
Select * from user_constraints c where c. constraint_type = 'r' and c. table_name = women
Query the names of Columns with foreign key constraints:
Select * from user_cons_columns cl where cl. constraint_name = foreign key name;
Query the column name of the key of the referenced table:
Select * from user_cons_columns cl where cl. constraint_name = foreign key reference table key name;