Procedure receives a select text with runtime parameters and creates Excel file.
| VAR | /*! VAR CHAR|NUMBER|DATE|AS_IS [Date Format] {SQL expression} ; !*/ Define variable |
| BEFORE | /*! BEFORE {PL/SQL block}; !*/ Execute PL/SQL block before query |
| AFTER | /*! AFTER {PL/SQL block};!*/ Execute PL/SQL block after query |
| EXPR | /*! EXPR CHAR|NUMBER|AS_IS {SQL expression};!*/ Put on this place expression result |
| IS_NULL | /*! IS_NULL :parameter [{]string [}]; !*/ If :parameter is null put on this place {string} |
| IS_NOT_NULL | /*! IS_NOT_NULL :parameter [{]string [}]; !*/ If :parameter is not null put on this place {string} |
| IIF_EXPR | /*! IIF_EXPR [{] boolean expression [}] {string if TRUE} [{]string if FALSE [}]; !*/ If boolean expression is true put on this place {string if TRUE} else {string if FALSE} |
| TITLE | /*! TITLE Columns count [{]Title [}]; !*/ Define super title for a few columns |
| ALIAS | /*! ALIAS FieldName [{]Alias [}]; !*/ Define column title different from column name |
| IF_CONTINUE | /*! IF_CONTINUE [{SQL expression [}]; !*/ Check {SQL expression} and if one is not null to break execution |
| BOTTOM_SUM | /*! BOTTOM_SUM [{] Total row title [}] B […]; !*/ Place summary formulas on bottom of columns |
| ROW_SUM | /*! ROW_SUM [{] Total column title [}] A [B …]; !*/ Place summary formulas on end of row |