This discussion is archived
1 Reply Latest reply: Mar 20, 2013 8:23 AM by chenda RSS

using a full outer join in an Oracle cql query

997545 Newbie
Currently Being Moderated
Hi everybody!
I am currently using Oracle CEP and I want to use a Full out join in order to aggregate somme streams. Is there any way to do that? It seems that you can either use a right or a left join.
Thanks a lot for your help!

Edited by: 994542 on 19 mars 2013 05:38
  • 1. Re: using a full outer join in an Oracle cql query
    chenda Newbie
    Currently Being Moderated
    Hello,

    You can refer to the CQL guide: http://docs.oracle.com/cd/E23943_01/apirefs.1111/e12048/queries.htm#CIHEFDGI, where it also describe the inner/outer join.
    There is a sample provide call cql provided with the installation where you can test CQL using CEP Visualizer : reference can be found
    http://docs.oracle.com/cd/E23943_01/doc.1111/e14476/examples.htm#CIHIJHHJ

    An easy way to play around with CQL is to build a simple CEP flow : CSV adapter->channelIN->CQL processor->channelOUT-> Listener (define also the needed event type).
    Then use the CEP Visualizer to test or create (through wizzard) your CQL statement.

    Regards,
    chenda

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points