Re: Derived Time Series
Hi Peter,
Thanks for your answer!
However, I don't think that would fly. I just checked in the manual, and it says:
"A common table expression is a named temporary result set that exists only within the execution scope of a single SQL statement"
I have roughly 40000 derived series that I need to create! And users need to be able to query them all the time. In the case of CTEs, they would be created anew everytime somebody issues a SELECT statement.
Subject
Written By
Posted
November 14, 2018 02:22AM
November 14, 2018 11:43AM
Re: Derived Time Series
November 15, 2018 01:52AM
November 15, 2018 11:10AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.