Insert data from a view based on function

From: Katia Suntseva <katrin_sun_at_yahoo.com>
Date: 4 Sep 2002 14:26:02 -0700
Message-ID: <15d91a99.0209041326.3b8ee810_at_posting.google.com>


Hi all,

I have a problem with inserting data from a view that was created like:

create or replace view aaa (a1, a2, a3..) AS select p1, p2,get_smth(w1, w2), get_smth(a1, a2), ... from bbb;

When I select something from this view time is OK. But if I try to insert the same select into another table it takes a lot. Where I'm wrong?

Thanks in advance,
Katia S. Received on Wed Sep 04 2002 - 23:26:02 CEST

Original text of this message