SQL reference

OpenText™ Analytics Database offers a robust set of SQL elements that allow you to manage and analyze massive volumes of data quickly and reliably, including:.

OpenText™ Analytics Database offers a robust set of SQL elements that allow you to manage and analyze massive volumes of data quickly and reliably, including:

  • Language elements such as keywords, operators, expressions, predicates, and hints

  • Data types including complex types

  • Functions including database-specific functions that take advantage of the database's unique column-store architecture

  • SQL statements that let you write robust queries to quickly return large volumes of data

In this section