Re: newbie help- Two Long fields in one table

I just wanted to thank everyone for the responses. I had a feeling I misunderstood the use of the LONG data type and I think I did. I come from a SQL Server environment (thus the newbie designation in the subject) and there are techniques and limitations in that environment that don't translate to Oracle. The SQL Server version I used featured "Text," a long-text field that was only field of its type. I am interested in texting the CLOB, but... did I mention this was a legacy db in Oracle 7.3.4? Could the project get any more confusing?

Either way thanks to all who replied for setting me on the right track.

Galen Boyer <galenboyer_at_hotpop.com> wrote in message news:<un0sjrn44.fsf_at_hotpop.com>...
> On 22 Jul 2002, bbcrock_at_hotmail.com wrote:
> > suddnly I find out that I can't use two
>
> [whatever might cause this issue]
>
> > in one table.
>
> You could solve this by defining more than one physical table and then
> the relational object presented to the client would join them together
> returning the relations you have designed.
Received on Tue Jul 23 2002 - 09:17:59 CDT