Re: [PL/SQL NEWBIE]Detect Varchar2 field length

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Sun, 28 Nov 2004 12:55:23 -0800
Message-ID: <1101675231.40369@yasure>

Alex NSB wrote:

> Catherine wrote:
>

>>Perhaps a function that will check
>>LENGTH(whatever) <= DATA_LENGTH
>>where DATA_LENGTH is queried from ALL_TAB_COLUMNS?
>>Good luck!

>
>
> Catherine,
>
> thanks for taking time to reply.
>
> I always tend to forget the existence of those tables, so your tip was
> really helpful.
>
> I only had one minor issue with CLOBs (the reported length is 4000) but I
> worked around it.
>
> Regards.
>
> Alessandro

CLOBS are 4GB not 4KB.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Sun Nov 28 2004 - 14:55:23 CST