It's impossibile to select LONG datatype in SQL*Plus. If you selecting
LONG column into variable, remember, that you can use only 32K of data
for variables.
Michel Cadot wrote:
>
> I think you make the query with SQL*Plus, so try:
> Set LONG 10000
> and you will get the entire text.
> The defaut for LONG parameter is 80 characters
> that is you get only the first 80 characters of LONG field.
>
> Nandakumar a écrit dans le message <7qhmgq$dmn$1_at_nnrp1.deja.com>...
> >When i do a select on a field of LONG datatype, only a part of its value
> >is selected or displayed. Can someone say how to get the full value
> >displayed?
> >
> >For instance, users_triggers table has a LONG field called TRIGGER_BODY.
> >when i select this field for one of my triggers, an incomplete
> >definition appears as shown here.
> >--
> >BEGIN
> >update nanda.agent set user_number = (select user_number from www.users
> >w
Received on Wed Sep 01 1999 - 03:14:15 CDT
