Creating Table User Defined Functions
Intermediate
15 min.
Leverage SQLScript in stored procedures, user defined functions, and user defined libraries.
You will learn
- How to transform a procedure to a table function.
Prerequisites
- This tutorial is designed for SAP HANA Cloud.
- Tutorials: Creating Scalar User Defined Functions
There are application and scenarios where you need a table function instead of procedure to leverage the advantage of direct selects on the output, for example, filtering, sorting and grouping. In the following exercise, we show you how you can easily transform a procedure to a table function.