Re: LONG datatype/rpt

You should be able to control the output of your long columns using the following sqlplus commands:

set long xxx -- tells oracle how many characters to display when a long column

                         is retrieved

set wrap on    --  tells oracle that when the column width is hit and
there is still                          more data from the column, to wrap
and put it on the next line in                          the same column of

column <column_name> format a30

• tells oracle to print the column 30 characters wide then wrap if wrap on

Also, if you use pl/sql be aware that it will only retrieve the first 2000 characters of a long column from the database for processing...

Jack Richter Received on Sat Apr 29 1995 - 00:00:00 CEST