2 Replies Latest reply: Sep 27, 2012 7:44 AM by Gurjeet RSS

    displaying data in readable format

    Rahul_India
      select *from user_tables;
      TABLE_NAME                     TABLESPACE_NAME                CLUSTER_NAME                   IOT_NAME                       STATUS     PCT_FREE   PCT_USED  INI_TRANS  MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE  FREELISTS
      ------------------------------ ------------------------------ ------------------------------ ------------------------------ -------- ---------- ---------- ---------- ---------- -------------- ----------- ----------- ----------- ------------ ----------
      FREELIST_GROUPS LOG B   NUM_ROWS     BLOCKS EMPTY_BLOCKS  AVG_SPACE  CHAIN_CNT AVG_ROW_LEN AVG_SPACE_FREELIST_BLOCKS NUM_FREELIST_BLOCKS DEGREE     INSTANCES  CACHE TABLE_LO SAMPLE_SIZE LAST_ANAL PAR IOT_TYPE     T S NES BUFFER_ ROW_MOVE GLO USE
      --------------- --- - ---------- ---------- ------------ ---------- ---------- ----------- ------------------------- ------------------- ---------- ---------- ----- -------- ----------- --------- --- ------------ - - --- ------- -------- --- ---
      DURATION        SKIP_COR MON CLUSTER_OWNER                  DEPENDEN COMPRESS DRO
      --------------- -------- --- ------------------------------ -------- -------- ---
      JOB_GRADES                     USERS                                                                                        VALID            10                     1        255          65536                       1  2147483645
                      YES N          6          5            0          0          0           9                         0                   0          1          1     N ENABLED            6 03-SEP-12 NO               N N NO  DEFAULT DISABLED YES NO
                      DISABLED YES                                DISABLED DISABLED NO
      
      ERROR                          USERS                                                                                        VALID            10                     1        255          65536                       1  2147483645
                      YES N          1          5            0          0          0          84                         0                   0          1          1     N ENABLED            1 03-SEP-12 NO               N N NO  DEFAULT DISABLED YES NO
                      DISABLED YES                                DISABLED DISABLED NO
      
      TABLE_NAME                     TABLESPACE_NAME                CLUSTER_NAME                   IOT_NAME                       STATUS     PCT_FREE   PCT_USED  INI_TRANS  MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE  FREELISTS
      ------------------------------ ------------------------------ ------------------------------ ------------------------------ -------- ---------- ---------- ---------- ---------- -------------- ----------- ----------- ----------- ------------ ----------
      FREELIST_GROUPS LOG B   NUM_ROWS     BLOCKS EMPTY_BLOCKS  AVG_SPACE  CHAIN_CNT AVG_ROW_LEN AVG_SPACE_FREELIST_BLOCKS NUM_FREELIST_BLOCKS DEGREE     INSTANCES  CACHE TABLE_LO SAMPLE_SIZE LAST_ANAL PAR IOT_TYPE     T S NES BUFFER_ ROW_MOVE GLO USE
      --------------- --- - ---------- ---------- ------------ ---------- ---------- ----------- ------------------------- ------------------- ---------- ---------- ----- -------- ----------- --------- --- ------------ - - --- ------- -------- --- ---
      DURATION        SKIP_COR MON CLUSTER_OWNER                  DEPENDEN COMPRESS DRO
      --------------- -------- --- ------------------------------ -------- -------- ---
      
      TEST_A                         USERS                                                                                        VALID            10                     1        255          65536                       1  2147483645
                      YES N          3          5            0          0          0          16                         0                   0          1          1     N ENABLED            3 03-SEP-12 NO               N N NO  DEFAULT DISABLED YES NO
                      DISABLED YES                                DISABLED DISABLED NO
      
      COLLECTIONS_EG                 USERS                                                                                        VALID            10                     1        255          65536                       1  2147483645
                      YES N                                                                                                                             1          1     N ENABLED                        NO               N N NO  DEFAULT DISABLED NO  NO
      
      TABLE_NAME                     TABLESPACE_NAME                CLUSTER_NAME                   IOT_NAME                       STATUS     PCT_FREE   PCT_USED  INI_TRANS  MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE  FREELISTS
      ------------------------------ ------------------------------ ------------------------------ ------------------------------ -------- ---------- ---------- ---------- ---------- -------------- ----------- ----------- ----------- ------------ ----------
      FREELIST_GROUPS LOG B   NUM_ROWS     BLOCKS EMPTY_BLOCKS  AVG_SPACE  CHAIN_CNT AVG_ROW_LEN AVG_SPACE_FREELIST_BLOCKS NUM_FREELIST_BLOCKS DEGREE     INSTANCES  CACHE TABLE_LO SAMPLE_SIZE LAST_ANAL PAR IOT_TYPE     T S NES BUFFER_ ROW_MOVE GLO USE
      --------------- --- - ---------- ---------- ------------ ---------- ---------- ----------- ------------------------- ------------------- ---------- ---------- ----- -------- ----------- --------- --- ------------ - - --- ------- -------- --- ---
      DURATION        SKIP_COR MON CLUSTER_OWNER                  DEPENDEN COMPRESS DRO
      --------------- -------- --- ------------------------------ -------- -------- ---
                      DISABLED YES                                DISABLED DISABLED NO
      
      COUNTRIES                                                                                                                   VALID             0          0          0          0
                          N          4                                             0          19                         0                              1          1     N ENABLED            4 03-SEP-12 NO  IOT          N N NO          DISABLED YES NO
                      DISABLED YES                                DISABLED DISABLED NO
      
      DEPARTMENTS                    EXAMPLE                                                                                      VALID            10                     1        255          65536                       1  2147483645
      
      TABLE_NAME                     TABLESPACE_NAME                CLUSTER_NAME                   IOT_NAME                       STATUS     PCT_FREE   PCT_USED  INI_TRANS  MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE  FREELISTS
      ------------------------------ ------------------------------ ------------------------------ ------------------------------ -------- ---------- ---------- ---------- ---------- -------------- ----------- ----------- ----------- ------------ ----------
      FREELIST_GROUPS LOG B   NUM_ROWS     BLOCKS EMPTY_BLOCKS  AVG_SPACE  CHAIN_CNT AVG_ROW_LEN AVG_SPACE_FREELIST_BLOCKS NUM_FREELIST_BLOCKS DEGREE     INSTANCES  CACHE TABLE_LO SAMPLE_SIZE LAST_ANAL PAR IOT_TYPE     T S NES BUFFER_ ROW_MOVE GLO USE
      --------------- --- - ---------- ---------- ------------ ---------- ---------- ----------- ------------------------- ------------------- ---------- ---------- ----- -------- ----------- --------- --- ------------ - - --- ------- -------- --- ---
      DURATION        SKIP_COR MON CLUSTER_OWNER                  DEPENDEN COMPRESS DRO
      --------------- -------- --- ------------------------------ -------- -------- ---
                      NO  N          8          5            0          0          0          19                         0                   0          1          1     N ENABLED            8 03-SEP-12 NO               N N NO  DEFAULT DISABLED YES NO
                      DISABLED YES                                DISABLED DISABLED NO
      
      EMPLOYEES                      EXAMPLE                                                                                      VALID            10                     1        255          65536                       1  2147483645
                      NO  N         20          5            0          0          0          66                         0                   0          1          1     N ENABLED           20 03-SEP-12 NO               N N NO  DEFAULT DISABLED YES NO
                      DISABLED YES                                DISABLED DISABLED NO
      i want to display the data in readable format
      10g oracle.
        • 1. Re: displaying data in readable format
          Frank Kulash
          Hi,
          Rahul_India wrote:
          i want to display the data in readable format
          How to do that depends on what you consider "readable".

          SET PAGESIZE higher, to get fewer header rows.

          SET LINESIZE higher, if appropriate

          Look up the COLUMN command in the SQL*Plus manual The
          FORMAT
          FOLD_AFTER, FOLD_BEFORE
          TRUNCATED, WRAPPED, WORD_WRAPPED
          options are especially useful.

          Do you really need to see all the columns? If not, don't use SELECT *.

          Consider explicitly listing the columns in a different order. The output may be more readable if related columns are listed together, or one directly above the other. At any rate, you can probably pack multi-line output more tightly if you specify the order.

          Do you have a text editor where reading long lines is easier than it is in the SQL*Plus window? If so, SPOOL the output, and read the file it creates in your editor.
          • 2. Re: displaying data in readable format
            Gurjeet
            sql> est lines 8000;
            sql>


            and
            increase the buffer size for cmd