How to set output size in Sqldeveloper "script" option

Question

How to set output size in Sqldeveloper "script" option

Asked 8 years, 5 months ago

Viewed 1,788 times

1

Oracle - Sqldeveloper - Version 4.1.3.20 Build MAIN-20.78

When running an SQL block there are two options (Run Instruction or Run Script), in this option , after an update is made, there is a limitation in the output size , at which point of Sqldeveloper I can configure this output ?

There is a line break and need a single line.

Example

select *
from dba_tables 
where rownum < 2

OWNER                          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_ANALYZED PAR IOT_TYPE     T S NES
--------------------------------------- ------------- --- ------------ - - ---
BUFFER_ FLASH_C CELL_FL ROW_MOVE GLO USE DURATION        SKIP_COR MON
------- ------- ------- -------- --- --- --------------- -------- ---
CLUSTER_OWNER                  DEPENDEN COMPRESS COMPRESS_FOR DRO REA SEG RESULT_
------------------------------ -------- -------- ------------ --- --- --- -------
SYS                            ICOL$                          

OWNER                          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_ANALYZED PAR IOT_TYPE     T S NES
--------------------------------------- ------------- --- ------------ - - ---
BUFFER_ FLASH_C CELL_FL ROW_MOVE GLO USE DURATION        SKIP_COR MON
------- ------- ------- -------- --- --- --------------- -------- ---
CLUSTER_OWNER                  DEPENDEN COMPRESS COMPRESS_FOR DRO REA SEG RESULT_
------------------------------ -------- -------- ------------ --- --- --- -------
SYSTEM                         C_OBJ#                         

OWNER                          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_ANALYZED PAR IOT_TYPE     T S NES
--------------------------------------- ------------- --- ------------ - - ---
BUFFER_ FLASH_C CELL_FL ROW_MOVE GLO USE DURATION        SKIP_COR MON
------- ------- ------- -------- --- --- --------------- -------- ---
CLUSTER_OWNER                  DEPENDEN COMPRESS COMPRESS_FOR DRO REA SEG RESULT_
------------------------------ -------- -------- ------------ --- --- --- -------
                               VALID             0          0          0 

OWNER                          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_ANALYZED PAR IOT_TYPE     T S NES
--------------------------------------- ------------- --- ------------ - - ---
BUFFER_ FLASH_C CELL_FL ROW_MOVE GLO USE DURATION        SKIP_COR MON
------- ------- ------- -------- --- --- --------------- -------- ---
CLUSTER_OWNER                  DEPENDEN COMPRESS COMPRESS_FOR DRO REA SEG RESULT_
------------------------------ -------- -------- ------------ --- --- --- -------
         0                                  139264 

OWNER                          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_ANALYZED PAR IOT_TYPE     T S NES
--------------------------------------- ------------- --- ------------ - - ---
BUFFER_ FLASH_C CELL_FL ROW_MOVE GLO USE DURATION        SKIP_COR MON
------- ------- ------- -------- --- --- --------------- -------- ---
CLUSTER_OWNER                  DEPENDEN COMPRESS COMPRESS_FOR DRO REA SEG RESULT_
------------------------------ -------- -------- ------------ --- --- --- -------
                                 204800                                       1

OWNER                          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_ANALYZED PAR IOT_TYPE     T S NES
--------------------------------------- ------------- --- ------------ - - ---
BUFFER_ FLASH_C CELL_FL ROW_MOVE GLO USE DURATION        SKIP_COR MON
------- ------- ------- -------- --- --- --------------- -------- ---
CLUSTER_OWNER                  DEPENDEN COMPRESS COMPRESS_FOR DRO REA SEG RESULT_
------------------------------ -------- -------- ------------ --- --- --- -------
                             2147483645                                        

OWNER                          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_ANALYZED PAR IOT_TYPE     T S NES
--------------------------------------- ------------- --- ------------ - - ---
BUFFER_ FLASH_C CELL_FL ROW_MOVE GLO USE DURATION        SKIP_COR MON
------- ------- ------- -------- --- --- --------------- -------- ---
CLUSTER_OWNER                  DEPENDEN COMPRESS COMPRESS_FOR DRO REA SEG RESULT_
------------------------------ -------- -------- ------------ --- --- --- -------
         1                                       1 YES N     276957      10170 

OWNER                          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_ANALYZED PAR IOT_TYPE     T S NES
--------------------------------------- ------------- --- ------------ - - ---
BUFFER_ FLASH_C CELL_FL ROW_MOVE GLO USE DURATION        SKIP_COR MON
------- ------- ------- -------- --- --- --------------- -------- ---
CLUSTER_OWNER                  DEPENDEN COMPRESS COMPRESS_FOR DRO REA SEG RESULT_
------------------------------ -------- -------- ------------ --- --- --- -------
                                      0          0          0 

OWNER                          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_ANALYZED PAR IOT_TYPE     T S NES
--------------------------------------- ------------- --- ------------ - - ---
BUFFER_ FLASH_C CELL_FL ROW_MOVE GLO USE DURATION        SKIP_COR MON
------- ------- ------- -------- --- --- --------------- -------- ---
CLUSTER_OWNER                  DEPENDEN COMPRESS COMPRESS_FOR DRO REA SEG RESULT_
------------------------------ -------- -------- ------------ --- --- --- -------
                                     32                                       0

OWNER                          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_ANALYZED PAR IOT_TYPE     T S NES
--------------------------------------- ------------- --- ------------ - - ---
BUFFER_ FLASH_C CELL_FL ROW_MOVE GLO USE DURATION        SKIP_COR MON
------- ------- ------- -------- --- --- --------------- -------- ---
CLUSTER_OWNER                  DEPENDEN COMPRESS COMPRESS_FOR DRO REA SEG RESULT_
------------------------------ -------- -------- ------------ --- --- --- -------
                                      0 1          1          N     ENABLED  

OWNER                          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_ANALYZED PAR IOT_TYPE     T S NES
--------------------------------------- ------------- --- ------------ - - ---
BUFFER_ FLASH_C CELL_FL ROW_MOVE GLO USE DURATION        SKIP_COR MON
------- ------- ------- -------- --- --- --------------- -------- ---
CLUSTER_OWNER                  DEPENDEN COMPRESS COMPRESS_FOR DRO REA SEG RESULT_
------------------------------ -------- -------- ------------ --- --- --- -------
                                 276957 01/07/15      NO               N N NO  

OWNER                          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_ANALYZED PAR IOT_TYPE     T S NES
--------------------------------------- ------------- --- ------------ - - ---
BUFFER_ FLASH_C CELL_FL ROW_MOVE GLO USE DURATION        SKIP_COR MON
------- ------- ------- -------- --- --- --------------- -------- ---
CLUSTER_OWNER                  DEPENDEN COMPRESS COMPRESS_FOR DRO REA SEG RESULT_
------------------------------ -------- -------- ------------ --- --- --- -------
DEFAULT DEFAULT DEFAULT DISABLED YES NO                  DISABLED YES 

OWNER                          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_ANALYZED PAR IOT_TYPE     T S NES
--------------------------------------- ------------- --- ------------ - - ---
BUFFER_ FLASH_C CELL_FL ROW_MOVE GLO USE DURATION        SKIP_COR MON
------- ------- ------- -------- --- --- --------------- -------- ---
CLUSTER_OWNER                  DEPENDEN COMPRESS COMPRESS_FOR DRO REA SEG RESULT_
------------------------------ -------- -------- ------------ --- --- --- -------
SYS                            DISABLED DISABLED              NO  NO  YES 

OWNER                          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_ANALYZED PAR IOT_TYPE     T S NES
--------------------------------------- ------------- --- ------------ - - ---
BUFFER_ FLASH_C CELL_FL ROW_MOVE GLO USE DURATION        SKIP_COR MON
------- ------- ------- -------- --- --- --------------- -------- ---
CLUSTER_OWNER                  DEPENDEN COMPRESS COMPRESS_FOR DRO REA SEG RESULT_
------------------------------ -------- -------- ------------ --- --- --- -------
DEFAULT

1 answer

Browser other questions tagged oracle sqldeveloper

You are not signed in. Login or sign up in order to post.

by Motta • **3,568** points · Answer 1 · 2016-07-26T14:44:09+00:00

I managed to sort it out like this :

I create the following script in . sql file (text)

set linesize 10000
set pagesize 10000

Going to Tools / Preferences / Database point this file

I do not know if it is the best solution , because the name of the columns is truncated.

and point the way