LONG datatype

From: pai <p_at_zainet.com>
Date: Wed, 24 Mar 1999 18:02:41 -0500
Message-ID: <d1eK2.26$A7.1024_at_client.news.globix.net>

[Quoted] Oracle dis-allow Long datatype included in a sub-query statement, I wonder if there is any alternative for this?

Example like ,

first,
create table sales
(

  department char(10),
  detail long
);

create unique index sales_dep on sales (department);

then,
rename table sales to sales_temp;
create table sales
(

  department char(10),
  salesperson char(10),
  detail long
);

insert into sales select
department,
'BILL',
detail
from sales_temp;

drop table sales_temp;

create unique index sales_dep on sales (department, salesperson);

The above senario does not work because column 'detail' is a long datatype.

Any suggestion will be appreciated. Received on Thu Mar 25 1999 - 00:02:41 CET