on 12-12-2017 2:41 PM
Is there a way to keep the results provided from a calculation view into a temporary table?
The idea here would be to have a parent calculation view that invokes several children calculation views, keeping their results stored in temp tables so it can be heavily manipulated in the parent calculation views.
When trying to write the results to a temp table I get: "DDL is/are not supported in read-only procedure" I understand that as a view, it cannot write data, but I wonder if there is any other strategy to save a aggregation result so it can me manipulated later on.
Hi,
you can try something like this in a procedure:
upsert"SCHEMA"."TABLE"
select a, b,
from VIEW
where .....
groupby .......
end;
Best regards
Thorsten
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.