Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: length of a long raw column
Use the vsize function.
Hth,
Sybrand Bakker, Oracle DBA
Thomas Kober <t.kober_at_bigfoot.de> schreef in berichtnieuws
392A4A4C.F89BFAFF_at_bigfoot.de...
> Hi Oracle PL/SQL experts,
>
> how do i examine the length of a long raw column
> with PL/SQL and sqlplus?
>
> Example:
> create table foobar (id number, foo long raw);
> insert into foobar values (1, '010101');
>
> select length(foo) from foobar
> *
> ERROR at line 1:
> ORA-00932: inconsistent datatypes
>
> Can Oracle PL/SQL experts there help me?
>
> Thanks
> Thomas
Received on Wed May 24 2000 - 00:00:00 CDT