I have recently started working on a oracle event processing application.In our case,we dont have a streaming data coming as input to the application but we have a relational table which we need to hit every 5 seconds,select some data and update the table accordingly.So i can say that the input to our application would be a select from a static table.When we open the visuallizer ,we can see the applications running on the oep server and in the cql rules tab,we can see the rules formed for streaming data for ex: select * from helloworldinputstream.My requirement is to display the select query in the cql rules tab which i wrote for fetching the data from a relational table.How to proceed?
Thanks.