Oracle Query table field information (contains comments) ____oracle

Sql

SELECT
    t1.*, T2. COMMENTS
from
    (
        SELECT
            column_name,
            data_type,
            data_length,
            Data_default,
            NULLABLE,
            column_id
        from
            all_tab_columns
        WHERE
            table_name = ' table_name '
        ORDER BY
            column_id ASC
    ) T1 left
JOIN (
    SELECT
        *
    from
        user_col_comments
    WHERE
        table_name = ' table_name '
) T2 on T1. COLUMN_NAME = T2. column_name;

Table Introduction

All_tab_columns: Table field details
User_col_comments: The table space inside the annotation, the field, the corresponding table name.