Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Column Width

Status
Not open for further replies.
ChiTownDiva

ChiTownDiva

Technical User
Jan 24, 2001
273
US
Dumb question comming...

How do I set the column width? I know it's not:

SET WIDTH "NAME" A20.

It's thursday and I'm having a brain fart.

Thanks.


ChiTownDivaus [ponytails2]
 
Sort by date Sort by votes
column a format a20

where a is a column name. Although I am not sure i believe "NAME" is a reserved for oracle.

Anand
 
Upvote 0 Downvote
Hi,
I'm assuming for Output in SqlPlus:

column Name format a20

[profile]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Livia8
  • Locked
  • Question
SQL script to find number of characters allowed in "Description" column of "AP_INVOIC 2
Replies
5
Views
636
Livia8
Livia8
Andrzejek
  • Locked
  • Question
Modify columns - parts of virtual column 2
Replies
8
Views
2K
carp
carp
EM1107
  • Locked
  • Question
Insert date and time using UTC time in a DATE column
Replies
14
Views
2K
EM1107
EM1107
rk68
  • Locked
  • Question
Display rows as column header
Replies
3
Views
291
Beilstwh
Beilstwh
LarrySteele
  • Locked
  • Question
Trying to Transpose Columns to Rows w/ Field Names 1
Replies
9
Views
1K
carp
carp

Part and Inventory Search

Sponsor

Back
Top