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

Typing and expressions

CQL native types are similar to Java with some additional RDBMS types. They are defined as follows:

  • BIGINT: This is equivalent to Java long
  • BOOLEAN: This is equivalent to Java boolean
  • BYTE(size): This is equivalent to an array of Java byte
  • CHAR(size): This is equivalent to a Java String or an array of Java char
  • DOUBLE: This is equivalent to Java double
  • FLOAT: This is equivalent to Java float
  • INTEGER: This is equivalent to Java int
  • INTERVAL: This represents an interval of time, and is similar to Oracle RDBMS interval data type
  • TIMESTAMP: This is equivalent to Java DateTime class
  • XMLTYPE: This represents XML data

The numeric data types of bigint, double, and integer support the following comparison operators:

  • = (equality)
  • <> (inequality) ...

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