Oracle View table Structure

Oracle View table Structure

Using desc

desc log

The log table is structured as follows

名称        空值         类型------    --------    -------------ID         NOT NULL     NUMBERUSERID                  NUMBER(38)DEPT                    NUMBER(38)LOG                     VARCHAR2(255)

Direct Dictionary Table

Check Dict table

selectfrom dict

The results are as follows

Then through the comment can be until the lookup table, the View column information we need to check USER_TAB_COLUMNS or USER_TAB_COLS , other such as indexes, users and other information has a corresponding table.
Check User_tab_columns table

selectfromwhereupper(‘log‘);

As a result, you can see the table structure.

Reference

Oracle Data Dictionary
Summary of common data dictionaries in Oracle

Oracle View table Structure