Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: newbie help- Tweo Long fields in one table

Re: newbie help- Tweo Long fields in one table

From: Anurag <avdbi_at_hotmail.com>
Date: Mon, 22 Jul 2002 20:20:33 -0400
Message-ID: <ujp8am1hdurn49@corp.supernews.com>


Permitting your Oracle version (which you should specify), You should use CLOB's instead ,,, and read up on LOB's. This is just one limitation you hit ... there are many regarding long datatype.

Anurag

"D" <bbcrock_at_hotmail.com> wrote in message news:22e171df.0207221306.640bcd_at_posting.google.com...
> help, I have an ER Diagram that is nice and approved by the clients
> and suddnly I find out that I can't use two long fields in one table.
> The text in each field varies, but is probably about 1500 chr max.
> How would you design the table so that it works in Oracle?
>
> thanks!
>
> Don
Received on Mon Jul 22 2002 - 19:20:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US