O'Reilly logo

Getting Started with Oracle Event Processing 11g by Lloyd Williams, Robin J. Smith, Alexandre Alves

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Retrieving external tables using SQL

As you have learned in Chapter 5, Coding with CQL, CQL supports the concepts of both streams and relations. Relations are an abstract definition that can represent a database table. So much so that in Chapter 7, Using Tables and Caches for Contextual Data, you learned how to populate a relation with data coming from either a RBMS table or a distributed cache. This is done by respectively specifying a table or a cache and linking them to a processor in the EPN.

However, there are cases where you may need additional flexibility when retrieving data from a RDBMS table to be used in CQL. For example, you may need to invoke some PL/SQL function, or you may want to aggregate the data in some particular way before ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required