ORACLE "desc table"对应的SQL语句

最新推荐文章于 2024-09-24 10:30:00 发布

yfleng2002

最新推荐文章于 2024-09-24 10:30:00 发布

阅读量2.4w

点赞数 1

文章标签： table oracle sql null float date

本文链接：https://blog.csdn.net/yfleng2002/article/details/7399573

版权

desc test

等同于

 SELECT OWNER,
         TABLE_NAME,
         COLUMN_NAME,
         DATA_TYPE
         || DECODE (
               DATA_TYPE,
               'NUMBER', DECODE (
                               '('
                            || NVL (TO_CHAR (DATA_PRECISION), '*')
                            || ','
                            || NVL (TO_CHAR (DATA_SCALE), '*')
                            || ')',
                            '(*,*)', NULL,
                            '(*,0)', '(38)',
                               '('
                            || NVL (TO_CHAR (DATA_PRECISION), '*')
                            || ','
                            || NVL (TO_CHAR (DATA_SCALE), '*')
                            || ')'),
               'FLOAT', '(' || DATA_PRECISION || ')',
               'DATE', NULL,
               'TIMESTAMP(6)', NULL,
               '(' || DATA_LENGTH || ')')
            AS DATA_TYPE,
         DATA_LENGTH,
         NULLABLE
    FROM DBA_TAB_COLUMNS
   WHERE OWNER IN ('OWNER')
         AND TABLE_NAME = UPPER ('table_name')
 ORDER BY OWNER, TABLE_NAME, COLUMN_ID;