Dynamic Column Selection

There are some scenarios where we need to specify the columns to select or the column selection function dynamically i.e. through a variable or function arguments. Two common scenarios are when we wish to build a reusable data manipulation function and when we wish to separate parameter specifications (e.g. column names to select) from the data manipulation logic.

In this section we cover the following dynamic column selection scenarios:

• Column Specifications where we specify column names dynamically as an environment variable or a SQL procedure argument.