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>
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