☰
d2jsp
Rules
Help
Forum Gold FAQ
Live Streams
Photo Gallery
Hourly Raffle
Ladder Slasher
Log In
Register
Log In
Register
Account Recovery
Resend Validation Email
d2jsp Forums
>
Off-Topic
>
Computers & IT
>
Programming & Development
> Question On Oracle > Column Width Default?
Add Reply
New Topic
New Poll
Views: 170
Replies: 2
Track Topic
NinjaSushi
Member
Posts: 35,456
Joined: Jan 25 2009
Gold
:
1,173.00
#1
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.
rockonkenshin
Member
Posts: 11,637
Joined: Feb 2 2004
Gold
:
434.84
#2
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.
NinjaSushi
Member
Posts: 35,456
Joined: Jan 25 2009
Gold
:
1,173.00
#3
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
© 2003-2026 d2jsp
Contact