2 LONGS in 1 TABLE

From: Axel Rose <rose_at_wmdhh.wmd.de>
Date: 1995/06/19
Message-ID: <1995Jun19.215525.24485_at_wmdhh.wmd.de>#1/1

Hi Netters,

Current available versions of Oracle (7.1) do not support more than a single long column per table
create table longy( n number, l1 long, l2 long); ORA-001754 .. only one long per table ..

1.
What workarounds do you use?

2.
Are views a usable solution?

create table longy1( n1 number, l1 long);
create table longy2( n2 number, l2 long);
create view v_longy( n, l1, l2 ) as

(select n1, l1, l2 from longy1, longy2 where n1 = n2);

3.
Is Oracle planning a solution for future versions?

4.
varchar2 greater than 2000 chars would be a solution too. Is this urgently needed extension scheduled at Oracle ??

Thanks for any opinnion or hint, Axel

--
Axel Rose - Hamburg, Germany     "Ich bin der Geist, der stets verneint!
e-mail: rose_at_wmdhh.wmd.de         Und das mit Recht; denn alles, was entsteht,
phone : +49-40-58958-236          Ist wert, dass es zugrunde geht;
fax   : +49-40-58958-199          Drum besser waer's, dass nichts entstuende."

Received on Mon Jun 19 1995 - 00:00:00 CEST