Re: info reqd regarding character datatype in oracle
Date: Mon, 30 Jul 2001 13:24:10 GMT
Message-ID: <_dd97.74748$Xr6.343680_at_news-server.bigpond.net.au>
I suppose some people don't always realise the relevance when asking these questions...
Tonster
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news:a20d28ee.0107232349.4f3c5e97_at_posting.google.com...
> nisk_at_rediffmail.com (nishad) wrote in message
news:<23ad140f.0107230813.6b3158b6_at_posting.google.com>...
> > i need to 've character datatype columns in a table with size
> > exceeding 70000. which 'datatype' i've to use for it. i want more than
> > one column of this type in one table. kindly help
>
> If you have Oracle 8.0 or higher - which you don't mention (why is
> this so difficult for everyone? Remember most members of this group
> are not clairvoyant) you should use a CLOB, and you can have multiple
> CLOBs per table.
> In Oracle 7 you are limited to 1 Long per table, no other solutions
> being available.
>
> Hth,
>
> Sybrand Bakker, Senior Oracle DBA
Received on Mon Jul 30 2001 - 15:24:10 CEST