I need some help with forecasting data in Oracle. I have a set of data in a table called MEASUREMENTS looking like that:
CITY DATA VALUE DATE
C1 T 19.6 2017-10-02 19:01
C1 p 1048.6 2017-10-02 19:01
C1 H 60 2017-10-02 19:01
C2 p 1023.1 2017-10-02 19:01
C2 T 28 2017-10-02 19:01
C2 H 30 2017-10-02 19:01
C1 T 21.6 2017-10-02 20:01
C1 p 1041.6 2017-10-02 20:01
C1 H 50 2017-10-02 20:01
C2 p 1053.1 2017-10-02 20:01
C2 T 28.5 2017-10-02 20:01
C2 H 31 2017-10-02 20:01
Its infinite series of data (at least a lot of data). Created algorithm should forecast VALUE in a given time. To call it: MEASUREMENT(CITY, VALUE, FUTURE_DATE), which should predict the chosen value in the future. I know that Oracle provides forecast method, but I'm stuck. Any one knows or maybe have some example of Oracle forecast using Holt model? Thanks in advance