Re: How to initialize varchar2 of infinite length

From: Noons <>
Date: Tue, 27 Jan 2015 20:42:02 +1100
Message-ID: <ma7mge$ecv$>

On 27/01/2015 5:25 PM, 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?

A few ideas.

varchar(max) in MSSQL is 2^31-1, which is a lot shorter than infinite. Go here for other limit definitions:

In Oracle, you use CLOB instead of varchar2 for very large character columns. That gives you 4GB.
Again, here are various Oracle limits: Received on Tue Jan 27 2015 - 10:42:02 CET

Original text of this message