oracle 查询表名和字段名

来源：互联网发布：java二叉树遍历算法编辑：程序博客网时间：2024/04/28 01:00
select *from all_Tab_Columnswhere column_name='...' and table_name = '...';desc all_Tab_ColumnsName                 Null     Type          -------------------- -------- ------------- OWNER                NOT NULL VARCHAR2(30)  TABLE_NAME           NOT NULL VARCHAR2(30)  COLUMN_NAME          NOT NULL VARCHAR2(30)  DATA_TYPE                     VARCHAR2(106) DATA_TYPE_MOD                 VARCHAR2(3)   DATA_TYPE_OWNER               VARCHAR2(120) DATA_LENGTH          NOT NULL NUMBER        DATA_PRECISION                NUMBER        DATA_SCALE                    NUMBER        NULLABLE                      VARCHAR2(1)   COLUMN_ID                     NUMBER        DEFAULT_LENGTH                NUMBER        DATA_DEFAULT                  LONG()        NUM_DISTINCT                  NUMBER        LOW_VALUE                     RAW(32 BYTE)  HIGH_VALUE                    RAW(32 BYTE)  DENSITY                       NUMBER        NUM_NULLS                     NUMBER        NUM_BUCKETS                   NUMBER        LAST_ANALYZED                 DATE          SAMPLE_SIZE                   NUMBER        CHARACTER_SET_NAME            VARCHAR2(44)  CHAR_COL_DECL_LENGTH          NUMBER        GLOBAL_STATS                  VARCHAR2(3)   USER_STATS                    VARCHAR2(3)   AVG_COL_LEN                   NUMBER        CHAR_LENGTH                   NUMBER        CHAR_USED                     VARCHAR2(1)   V80_FMT_IMAGE                 VARCHAR2(3)   DATA_UPGRADED                 VARCHAR2(3)   HISTOGRAM                     VARCHAR2(15)
0 0