How to configure output size in SqlDeveloper's "script" option

Question

How to configure output size in SqlDeveloper's "script" option

Navigation

#1 by (1 votes)

1

Oracle - SqlDeveloper - Version 4.1.3.20 Build MAIN-20.78

When executing a SQL block I have two options (Execute Statement or Execute Script), in this option, after an update done, a limitation exists on the output size, at what point of SqlDeveloper can I configure this output?

There is a line break and I 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

oracle sqldeveloper

asked by anonymous 22.07.2016 / 21:32

1 answer

Closing a running audio Django rest and angularjs error cors

score 1 · Answer 1

I was able to solve this:

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

set linesize 10000
set pagesize 10000

Going to Tools / Preferences / Database I point this file

I do not know if this is the best solution, because the column names are truncated.

and I point the way