sqlexasolution

Exasol feature for writing query like plsql


I have multiple select statements and I have to execute a particular select statement based on parameter we passed to script in Exasol. This is pretty known to me in SQL server where we can achieve this functionality using inline function or stored procedure.


Solution

  • Exasol has a similar facility - it is called scripting in Exasol and is described in detail (with examples) in Section 3.5 of the Exasol User Manual. The manual can be downloaded from the Exasol website here :

    https://www.exasol.com/portal/display/DOC/User+Manual+6.0