select on LONG!

From: Nandakumar <N.Kumar_at_rocketmail.com>
Date: Tue, 31 Aug 1999 22:55:27 GMT
Message-ID: <7qhmgq$dmn$1@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 Tue Aug 31 1999 - 17:55:27 CDT