Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: length of a long raw column

Re: length of a long raw column

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/05/24
Message-ID: <959193575.8241.0.pluto.d4ee154e@news.demon.nl>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US