In your script window, execute "set pagesize 40". Does that stop the column headings before each row?
Also the right margin is going to 1/2 the output window instead of the whole pane.
I'm not sure I am visualizing this correctly. Can you show a screen shot?
sounds like your pagesize is set to a really low number like 1 or 2
and your linesize is set too short
in version 4.1, we default to SQL*Plus formatting defaults, which include a linesize of 80 and a pagesize of 15
So we previously set the linesize to default to the width of the window, we'll go back to that behavior - unless you've explicitly set it to something else to match your SQL*Plus scripts
you can run 'show all' or 'show pagesize' to see what your settings are now.
I see what you're saying now. Read Jeff's response. The other issue is due to your linesize. Then read Jeff's link he posted. I bet you have set pagesize and linesize in a login.sql script.
OK - thanks everyone. I found the SHOW ALL through googling so I was on the right track. This is how I resolved it though (don't like it but it worked).
I did a SET PAGESIZE 50000; and SET LINESIZE 140; It looks much better. It looks like the PageSize will write out the column names after the setting is reached (I played with different sizes). My SHOWALL settings were:
appinfo is OFF and set to "SQL Developer"
colsep " "
concat "." (hex 5c)
FEEDBACK ON for 6 or more rows
headsep "|" (hex 7c)
PAUSE is OFF
space " "
sqlprompt "SQL> "
USER is "XXXXXX"
wrap : lines will be wrapped
Not sure what my older version has on my virtual environment (v3.0.04) since I can't do a SHOW PAGESIZE; or SHOW LINESIZE; on it. I never had to change settings on this version except for NLS date format and Max Rows/Lines in script.
There was a change in v4.x ( I cant remember the exact number) where more of the SQL*Plus commands like pagesize and linesize are integrated in SQL Dev. This is why you didn't have this experience in your older version.
Also found in Preferences > Code Editor > Show Visible Right Margin was checked off and had a value of 80. I unchecked it and the gray line went away.
These settings are connection-dependent in sqlplus. Is that the case now with SQLDeveloper, or do we have to set these values as a preamble to working with each connection?
can be set via a startup script that runs at connection time.