d2jsp
Log InRegister
d2jsp Forums > Off-Topic > Computers & IT > Programming & Development > Question On Oracle > Column Width Default?
Add Reply New Topic New Poll
Member
Posts: 35,456
Joined: Jan 25 2009
Gold: 1,173.00
Mar 19 2014 11:52pm
So here is a quick SS.



If you go to the insert row, the last column supposed to read REGION. As you can see the character length is dictating the length of the column name. Is there a way to make it present the entire column name? Thanks guys.
Member
Posts: 11,637
Joined: Feb 2 2004
Gold: 434.84
Mar 20 2014 06:01am
Try issuing the command when you start a SQL*Plus session:

Code

SET LINESIZE n


Where n is the character width of the columns you want. I would really recommend using SQLDeveloper instead of SQL*Plus as you don't have to deal with shit like this.
Member
Posts: 35,456
Joined: Jan 25 2009
Gold: 1,173.00
Mar 20 2014 09:16am
linesize doesn't fix the problem when a column heading is larger than the char value for the column. :/

I have thought of downloading the .bat for developer but sqlplus isn't so bad besides that tiny problem. Now if I could only get CODE::BLOCKS and Chromium to work on my Linux laptop I would be set.
Go Back To Programming & Development Topic List
Add Reply New Topic New Poll