Re: How to initialize varchar2 of infinite length

From: Mark D Powell <markp28665_at_gmail.com>
Date: Wed, 28 Jan 2015 10:51:04 -0800 (PST)
Message-ID: <efc59435-5a6e-4099-86fe-31598af021ae_at_googlegroups.com>


On Wednesday, January 28, 2015 at 6:40:12 AM UTC-5, Noons wrote:
> On 28/01/2015 2:21 AM, Mladen Gogala wrote:
>
>
> > Even CLOB is not infinite, it is at most 2G.
>
> According to the doc I mentioned, it's 8 TB to 128 TB depending on
> blocksize. Latest releases, mind you.
>
> > There is no such thing as infinity.
>
> Indeed.

8T to 128TB should just hold your average DBA's list of complaints about Oracle, developers, and life in general. 8-D Seriously, that is more than I ever want to see on a create table request.

  • Mark D Powell --
Received on Wed Jan 28 2015 - 19:51:04 CET

Original text of this message