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
>--
>
>Would appreciate any suggestion!
>Thanks
>
>Nandakumar
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Wed Sep 01 1999 - 03:06:54 CDT
