sqlplus_set describe linenum

describe
SP2-0281: describe 缺失設定選項
用法:  SET DESCRIBE [DEPTH {1|n|ALL}] [LINENUM {ON|OFF}] [INDENT {ON|OFF}]
describe linenum on
user_users;
           名稱                            是否為空? 型別
           ------------------------------- -------- -------------------------

    1      USERNAME                        NOT NULL VARCHAR2(30)
    2      USER_ID                         NOT NULL NUMBER
    3      ACCOUNT_STATUS                  NOT NULL VARCHAR2(32)
    4      LOCK_DATE                                DATE
    5      EXPIRY_DATE                              DATE
    6      DEFAULT_TABLESPACE              NOT NULL VARCHAR2(30)
    7      TEMPORARY_TABLESPACE            NOT NULL VARCHAR2(30)
    8      CREATED                         NOT NULL DATE
    9      INITIAL_RSRC_CONSUMER_GROUP              VARCHAR2(30)
   10      EXTERNAL_NAME                            VARCHAR2(4000)

 

注意：作用就是為每行結果集產生一個行編號，這樣有助於快速參考與比對