Oracle^® Business Intelligence Server Administration Guide > Oracle BI Server SQL Reference > SQL Syntax and Semantics >

SELECT Usage Notes

The Oracle BI Server treats the SELECT statement as a logical request. If aggregated data is requested in the SELECT statement, a GROUP BY clause is automatically assumed by the server. Any join conditions supplied in the query are ignored; the join conditions are all predefined in the repository.

The Oracle BI Server accepts the following SQL syntaxes for comments:

• /* */ C-style comments
• // Double slash for single-line comments
• # Number sign for single-line comments

The Oracle BI Server supports certain subqueries and UNION, UNION ALL, INTERSECT, and EXCEPT operations in logical requests. This functionality increases the range of business questions that can be answered, eases the formulation of queries, and provides some ability to query across multiple business models.

The Oracle BI Server supports the following subquery predicates in any conditional expression (for example, within WHERE, HAVING, or CASE statements):

• IN, NOT IN
• >Any, >=Any, =Any, <Any, <=Any, <>Any
• >Some, >=Some, =Some, <Some, <=Some, <>Some
• >All, >=All, =All, <All, <=All, <>All
• EXISTS, NOT EXISTS