Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Adjusting column length with varchar ;-(

Re: Adjusting column length with varchar ;-(

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 17 Nov 2005 06:27:30 +0100
Message-ID: <p35on11g4mdulmg0es6mqt2lpbmdollv07@4ax.com>


On 16 Nov 2005 21:17:15 -0800, "milkyway" <d0mufasa_at_hotmail.com> wrote:

>Hello again,
>
>I have a table that has (for one of the fields) VARCHAR2(64) - but -
>whenever I select in sqlplus using this field, the display is chopped
>off and I don't see the entire entry.
>
>What can I do to see the entire value (and not get a chopped off
>version)?
>
>TIA
column <column name> format a 64

and may be
set linesize <n>

As this is really basic stuff, I would recommend reading the sql*plus manual.
As would also urge you to stop cross-posting.

--
Sybrand Bakker, Senior Oracle DBA
Received on Wed Nov 16 2005 - 23:27:30 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US