Re: 2 longs in a table

[Quoted] "David W. Forslund" <dwforslund_at_yahoo.com> wrote in message news:3B9E7036.A88899B3_at_yahoo.com...
> Oracle tells me that I can't have two longs in a single table.
> I want to have a long as a key and as a foreign key to
> point to values in another (or the same table). The
> latter is essentially a linked list with long values. I've
> done this with other databases without any problems.
> How can I accomplish this with Oracle? I'm using 8.1.7.
>
> Thanks,
>
> Dave Forslund
>

You can't. The long datatype has been superseded by LOBs, which don't have the one per table restriction. As you don't state which type of data the columns are holding I can't say whether you need to use a CLOB or a BLOB. I doubt however you can use a CLOB or a BLOB as a key. Your documentation will give you the definitive answer.

Regards,

Sybrand Bakker, Senior Oracle DBA Received on Tue Sep 11 2001 - 22:59:03 CEST