Re: insert into one table with selects from 4 others

From: Jurij Modic <jmodic_at_src.si>
Date: Tue, 16 Mar 1999 22:33:16 GMT
Message-ID: <36eedbe7.6295136@news.siol.net>

On Tue, 16 Mar 1999 20:23:41 GMT, chrisoc_at_ans.net wrote:

>Thank you. Now here is a new wrinkle. I also need a column
>which is computed from v1and v2 in tablea.
>Not sure if it can be done at the same time.
>
>insert into tablea (v1, v2, v3, v4)
>select *
>from (select sysdate v1 from dual),
>(select avg(something) v2 from tableb),
>(select min(something) v3 from tablec),
>( select v2/v3 * 100 v4 from tablea);
>
>This fails to insert even one row.

Change it to:

insert into tablea (v1, v2, v3, v4)
select v1, v2, v3, v2/v3*100
from (select sysdate v1 from dual),
(select avg(something) v2 from tableb), (select min(something) v3 from tablec);

>Chris O'Connor

HTH,
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Tue Mar 16 1999 - 16:33:16 CST