Oracle SQLPlus Worksheet

mryan916 · #1 (**permalink**) 03-04-04, 14:36

When I run an SQLPlus query, the displayed width of each column is the width of the data item. This means that the column header for many fields is truncated. How do I override this default width in order to make the entire column header appear without being truncated. An example is below. The last column is titled DESTINATION, but only DES shows.

BAG_TAG_N ORI DES
--------- --- ---
3UA233468 TUL ORD
3UA233468 AVP ORD
3UA233468 ORD MLI

ss659 · #2 (**permalink**) 03-04-04, 18:55

Quote:

Originally posted by mryan916
When I run an SQLPlus query, the displayed width of each column is the width of the data item. This means that the column header for many fields is truncated. How do I override this default width in order to make the entire column header appear without being truncated. An example is below. The last column is titled DESTINATION, but only DES shows.

BAG_TAG_N ORI DES
--------- --- ---
3UA233468 TUL ORD
3UA233468 AVP ORD
3UA233468 ORD MLI

try: set linesize 120

Internet Services

Web Development

Digital Marketing

Consumer Tech