3.1.14.6 Smart Scan for Oracle Database 23ai Functions and Operators

Oracle Exadata System Software release 24.1.0 enables Exadata Smart Scan in conjunction with the following new functions and operators introduced in Oracle Database 23ai:

  • CEIL (datetime) function

  • CEIL (interval) function

  • FLOOR (datetime) function

  • FLOOR (interval) function

  • ROUND (interval) function

  • TRUNC (interval) function

  • TO_BOOLEAN function

  • IS FALSE predicate operator

  • IS NOT FALSE predicate operator

  • IS TRUE predicate operator

  • IS NOT TRUE predicate operator