columns and scrolling in sql plus

[princessinthetower]

I know about 'set linesize'. If I select * from a table with many columns, I can keep them from wrapping by increasing the linesize. However, I can't scroll to the right and see all the columns. Is there a setting I'm missing or something in Windows that will allow me to see all the columns?

 

[cliousa]

You can spool to text file and then see the results by scrolling right as much as your data goes.


Hope that helps,

clio_usa

http://www.dbaclick.com

 

[sem]

Try to resize window.

Regards, Dima

 

[princessinthetower]

Thanks, Cliousa, for the spool tip. I think this may be the only way if I don't want everything wrapped and unreadable.

 

[acct98]

Dima,

I tried to resize the window and it did not work [I currently have my Line Size set to 200]. Any Ideas?

 

[Turkbear]

Hi,
SqlPlus is not really designed to be a reporting tool, so it is not as flexible as one might like..Combine that with Windows' limitations ( SqlPLus would have to call an API function to generate a new window that had scroll bars) and it just will notbdo what you want. However, you can use other tools for that task..( SqlPlus Worksheet works well for this)

 

[sem]

Try to increase buffer width before resizing window.

Regards, Dima

 

[princessinthetower]

Turkbear has the right answer. I've figured it out since I first submitted the question. Thanks

 

[sem]

I don't agree neither with Turkbear nor with Infobabe: sql*plus indeed IS reporting tool, it supports a set of formatting commands and allows to create quite reach text-based (and HTML) reports. Though, as with any other CONSOLE application you should either read manuals CAREFULLY or just have some GURU beside you. The problem with scrolling on some Windows versions AFAIK may be resolved by changing both LINESIZE and BUFFER WIDTH (in SOME versions on SOME platforms, due to bug, I suppose,needs resizing window). You may do it in one shot using Options/Environment menu rather than explicit SET command.

Regards, Dima