Re: How to initialize varchar2 of infinite length
From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Tue, 27 Jan 2015 20:42:02 +1100
Message-ID: <ma7mge$ecv$1_at_dont-email.me>
Date: Tue, 27 Jan 2015 20:42:02 +1100
Message-ID: <ma7mge$ecv$1_at_dont-email.me>
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:
https://msdn.microsoft.com/en-us/library/ms143432.aspx
In Oracle, you use CLOB instead of varchar2 for very large character
columns. That gives you 4GB.
Again, here are various Oracle limits:
http://docs.oracle.com/cd/B19306_01/server.102/b14237/limits001.htm#i287903
Received on Tue Jan 27 2015 - 10:42:02 CET