Re: q: length of long data type column

Azad Bulla schrieb:

> try
> length(col_name)
>

Not quite, the test below blew up (column QUERY is of type LONG):

SQL> select length(query) from user_snapshots; select length(query) from user_snapshots

              *
ERROR at line 1:
ORA-00932: inconsistent datatypes

I would like to know the answer, too.

>
> azad
> Sydney Opera
>
> tedchyn_at_yahoo.com wrote:
>
> > sir, how do i find out the length of data stored in long data type
> > column ?
> > thnx ted
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.

--
To reply to me via email, please substitute the text no_spam with
mailbox in the return address.