I'm trying to draw a chart using sql query editor using a dynamic sql. I've built a part of the query in page 4 and I would like to use it into page 5.
In page 4 I built the query passing the parameters to a store procedure into a package in the database, receiving the part of the query. I need to use this way
This is the part of the structure query:
:P4_STRINGA_VIEW = from VIEW_OEE_MAC_MENSILE where V_COD_MACCHINA= 'REP03' and V_ANNO = '2020';
I've tryied to build the query witout the keyword "From" and this has been the result
Can anyone help to set in the right way?
Thanks in advanced for the help