Re: memo field

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Thu, 27 Jun 2002 17:05:16 GMT
Message-ID: <3D1B45B0.5D35B805@exesolutions.com>

supporto wrote:

> Can I define a memo field Access like varchar2 (4000) in a Oracle table ?
> Originally i was define it like a Oracle Long, but I can't create it more
> then one for table ....
>
> thanks a lot
> Ale

Not and have the same capability of formatted text.

If you can do VARCHAR2(4000) then presumably you are in Oracle 8i ... you don't say.

If so you should drop all LONGs, Oracle has already announced that they will not exist in the future, and move to CLOBs. And you can certainly have multiple CLOBs in a table.

Daniel Morgan Received on Thu Jun 27 2002 - 12:05:16 CDT