Oracle SQL Developer script output not displaying readable format

Question

I have queries that provide the output, but the output is really weird looking. It doesn't scroll over to look at the output, and the columns are really wide for things that are less than 20 characters. How do I get it to look normal? This is using Oracle SQL Developer. I searched online, but this doesn't seem to be what I need to do: format output archive. Although, I don't see how to get to the preference screen they are referring to either.

This is a portion of the output:

      RAK      SHEL SLT
---------- ---------- ------------------------------ PRT                                     BRDBND_
---------------------------------------- ---------- DSLAM
-------------------------------------------------- VEND
-------------------------------------------------------------------------------- MODE
-------------------------------------------------------------------------------- PORT_ADDR  CARRIER_ID
----------------- ----------------------------------------------------- CIRC_DE SERVICE SHELF_PT_NUM         CARD_PART_NUM
---------- ---------- ------------------------- ------------------------- CARD_PT_DESC             
-----------------------------------
    3317 270812 1179G1                 1170F1

As you can see, hopefully, it has really wide columns for the output, and column headers aren't at the top of the output window, it's in the output window. None of the output is more than 20 characters wide. I'm not sure why it's displaying that way.

Update: Plus, it's printing the column headers in the output window over and over again.

The problem wasn't the sql. It was the settings in developer. @ZynonPutneyII answered it already. — Michele
– Michele, Commented Jun 4, 2018 at 12:54
glad it's answered, but you made us guess. Next time show us you entire script + settings, then we can give you an educated answer — thatjeffsmith
– thatjeffsmith, Commented Jun 4, 2018 at 13:19

Zynon Putney II · Accepted Answer · 2018-05-31 18:25:59Z

4

Try adding this line at the beginning of your script. It appears that your SQL Developer settings are what is making this output unreadable.

NOTE: I am using SQL Developer version 18.1.0.095

Edit: Added command to suppress reprinting of headers (pagesize) to 80 lines.

set sqlformat ansiconsole;
set pagesize 80;

edited May 31, 2018 at 18:25

answered May 31, 2018 at 18:19

Zynon Putney II

6954 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Michele Over a year ago

It still seems to be printing the header every 10 output lines. It's a little better though.

Zynon Putney II Over a year ago

set pagesize 80 will make the output 80 lines before it reprints header.

Collectives™ on Stack Overflow

Oracle SQL Developer script output not displaying readable format

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related