Oracle query field details

Oracle query field details

The SQL statement used to query the detailed information of a field in Oracle contains the table name, field name, type, length, whether it is null, column number, and field remarks.

SELECT USER_TAB_COLS.TABLE_NAME as table name,

USER_TAB_COLS.COLUMN_NAME as column name,

USER_TAB_COLS.DATA_TYPE as data type,

USER_TAB_COLS.DATA_LENGTH as length,

USER_TAB_COLS.NULLABLE as is empty,

USER_TAB_COLS.COLUMN_ID as column number,

User_col_comments.comments as remarks

FROM USER_TAB_COLS

Inner join user_col_comments on

User_col_comments.TABLE_NAME = USER_TAB_COLS.TABLE_NAME

And user_col_comments.COLUMN_NAME = USER_TAB_COLS.COLUMN_NAME

Where USER_TAB_COLS.Table_Name = 'table name'

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