Re: How to initialize varchar2 of infinite length
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Tue, 27 Jan 2015 15:21:34 +0000 (UTC)
Message-ID: <pan.2015.01.27.15.22.07_at_gmail.com>
Date: Tue, 27 Jan 2015 15:21:34 +0000 (UTC)
Message-ID: <pan.2015.01.27.15.22.07_at_gmail.com>
On Mon, 26 Jan 2015 22:25:22 -0800, wE|rd0 wrote:
> I want to initialize varchar2 of infinite length. But, I read that the
> maximum i can initialize is varchar2(32767).
>
> varchar2(max) like that in sql server does not work either.
>
> Any ideas?
VARCHAR2 is not of infinite length and can be at most 4k or 32k, depending on the version. Even CLOB is not infinite, it is at most 2G. There is no such thing as infinity.
-- Mladen Gogala The Oracle Whisperer http://mgogala.byethost5.com Je suis CharlieReceived on Tue Jan 27 2015 - 16:21:34 CET