View User table and table field information in Oracle

1. view the table created by the user (Table Name and comment)

1. -- View the table name
2. Select*FromUser_tab_commentsWhereTable_nameLike 'Tb _ %';

If:

2. view the table name, column name, and field type information.

1. SelectCol. COLUMN_NAMEAsColumn name, col. NULLABLEAs ISNull,
2. Col. DATA_TYPE, col. DATA_LENGTH, col. DATA_PRECISION, col. DATA_SCALE, comm. COMMENTS
3. FromUser_tab_comments tabInner JoinUser_tab_columns colOnTab. TABLE_NAME = col. TABLE_NAME
4. Inner JoinUser_col_comments commOnCol. TABLE_NAME = comm. TABLE_NAMEAndCol. COLUMN_NAME = comm. COLUMN_NAME
5. WhereCol. TABLE_NAME ='Tp _ PC_BFEXMPLAN'
6. Order ByCol. COLUMN_IDAsc;

The result is as follows: