Logical SQL Reference

This appendix provides syntax and usage information for the Logical SQL statements understood by the Oracle BI Server. Oracle BI Server Logical SQL includes standard SQL, plus special functions (SQL extensions) such as AGO, TODATE, EVALUATE, and others. Logical SQL queries resolve to Presentation layer objects.

This appendix contains the following topics:

• About Logical SQL in Oracle Business Intelligence

• SQL Syntax and Semantics

• Aggregate, Running Aggregate, Time Series, and Reporting Functions

• String Functions

• Math Functions

• Calendar Date/Time Functions

• Conversion Functions

• Database Functions

• System Functions