Re: info reqd regarding character datatype in oracle
From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 24 Jul 2001 00:49:34 -0700
Message-ID: <a20d28ee.0107232349.4f3c5e97_at_posting.google.com>
Date: 24 Jul 2001 00:49:34 -0700
Message-ID: <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 Tue Jul 24 2001 - 09:49:34 CEST