Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    4

    Unanswered: Oracle SQLPlus Worksheet

    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

  2. #2
    Join Date
    Jan 2004
    Posts
    492

    Re: Oracle SQLPlus Worksheet

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •