rownum排序的问题

最新推荐文章于 2022-02-12 12:46:09 发布

rgb_rgb

最新推荐文章于 2022-02-12 12:46:09 发布

阅读量847

点赞数

分类专栏： oracle 文章标签： table sql

本文链接：https://blog.csdn.net/rgb_rgb/article/details/7776497

版权

oracle 专栏收录该内容

90 篇文章 0 订阅

订阅专栏

SQL> select rownum,column_name,data_type,column_id
2 from   dba_tab_columns
3 where owner= upper ('&1') and table_name = upper ('&2')
4 order by column_id;

    ROWNUM COLUMN_NAME                    DATA_TYPE                                                                         COLUMN_ID
---------- ------------------------------ -------------------------------------------------------------------------------- ----------
         7 CONTRACTNUMBER                 VARCHAR2                                                                                  1
         8 DEPTTYPE                       NUMBER                                                                                    2
         9 CATEGORYITEMCODE               VARCHAR2                                                                                  3
        10 DEPTCODE                       VARCHAR2                                                                                  4
        11 GOODSCODE                      VARCHAR2                                                                                  5
        12 SUPPLIERCODE                   VARCHAR2                                                                                  6
         1 PRICEMODE                      NUMBER                                                                                    7
         2 PURCHPRICE                     NUMBER                                                                                    8
         3 WITHHOLDINGRATES               NUMBER                                                                                    9
         4 MAXPURCHPRICE                  NUMBER                                                                                   10
         5 SUPPLYGOODSTIME                VARCHAR2                                                                                 11
         6 PRICECOMPENSATYPE              NUMBER                                                                                   12

12 rows selected

正确的顺序应是：

    ROWNUM COLUMN_NAME                    DATA_TYPE                                                                         COLUMN_ID
---------- ------------------------------ -------------------------------------------------------------------------------- ----------
         1 CONTRACTNUMBER                 VARCHAR2                                                                                  1
         2 DEPTTYPE                       NUMBER                                                                                    2
         3 CATEGORYITEMCODE               VARCHAR2                                                                                  3
         4 DEPTCODE                       VARCHAR2                                                                                  4
         5 GOODSCODE                      VARCHAR2                                                                                  5
         6 SUPPLIERCODE                   VARCHAR2                                                                                  6
         7 PRICEMODE                      NUMBER                                                                                    7
         8 PURCHPRICE                     NUMBER                                                                                    8
         9 WITHHOLDINGRATES               NUMBER                                                                                    9
        10 MAXPURCHPRICE                  NUMBER                                                                                   10
        11 SUPPLYGOODSTIME                VARCHAR2                                                                                 11
        12 PRICECOMPENSATYPE              NUMBER                                                                                   12

12 rows selected

什么原因呢？