Creating Excel file from Oracle PL/SQL stored package.
Support Oracle Reports trigger possibilities without Oracle Reports.
Predefine language for query parameters substitution and placeholders.
Configuration parameters.
Excel sheets support for few selects.
Procedure parameters:
- Query text
- File path
- Query parameters list
Predefine hints for usage in select statements
| VAR | /*! VAR CHAR|NUMBER ;!*/ |
| BEFORE | /*! BEFORE {PL/SQL block}; !*/ |
| AFTER | /*! AFTER {PL/SQL block};!*/ |
| EXPR | /*! EXPR CHAR|NUMBER {SQL expression};!*/ |
| IS_NULL | /*! IS_NULL <:parameter> [{]string [}]; !*/ |
| TITLE | /*! TITLE [{]Title [}]; !*/ |
| IS_NOT_NULL | /*! IS_NOT_NULL <:parameter> [{]string [}]; !*/ |
| IIF_EXPR | /*! IIF_EXPR [{] boolean expression [}] {string if TRUE} [{]string if FALSE [}]; !*/ |
| BOTTOM_SUM | /*! BOTTOM_SUM [{] Total row title [}] B […]; !*/ |
| ROW_SUM | /*! ROW_SUM [{] Total column title [}] A [B …]; !*/ |