Re: Long Datatypes

In article <9510111550.AA16816_at_tcsernet.tcs.ernet.in>, <krish_at_tcsernet.tcs.ernet.in> writes:
> Path:

noc.tor.hookup.net!nic.wat.hookup.net!hookup!news.mathworks.com!newsfeed.intern etmci.com!howland.reston.ans.net!math.ohio-state.edu!cs.utexas.edu!not-for-mail
> From: krish_at_tcsernet.tcs.ernet.in
> Newsgroups: comp.databases.oracle
> Subject: Long Datatypes
> Date: 11 Oct 1995 05:16:25 -0500
> Organization: UTexas Mail-to-News Gateway
> Lines: 20
> Sender: nobody_at_cs.utexas.edu
> Message-ID: <9510111550.AA16816_at_tcsernet.tcs.ernet.in>
> NNTP-Posting-Host: news.cs.utexas.edu
>
> Hi,
>
> Does anyone know how one can view long datatypes
> thru SQL*PLus so that one can view the entire content
> of the field. Could u pl. email the response -
> we do not have newsgroup access.
> Thanks,
>
> - smita
>
> --
>
> __________________________________________________________________
>
> Phone 91 22 2024828
> 91 22 2024881
> Fax 91 22 2875501
> krish_at_tcsernet.tcs.ernet.in
> __________________________________________________________________
>

Check the sqlplus user's guide 'set' command e.g. set long 3000 ... will allow
sqlplus to display a long up to 3000 chars. long. You can test this against the 
user_views table where the TEXT column is a long.

bonne chance,

\louis Received on Sat Oct 14 1995 - 00:00:00 CET