Q. What is the syntax to create an Array? Ans. An Array is a Single column table a one dimension structure to hold multiple values of same type. An Array CANNOT be used in SIGNATURE of a PROCEDURE. DECLARE < va_type> ARRAY = ARRAY(val1, val2,…) Q. What is use of UNNEST Function? Ans. UNNEST function is used to convert one or many arrays into a table. Syntax: Table_variable = UNNEST(:array_var) AS (column_name) Q. What are User Defined Functions in SAP HANA? Ans. User Defined Functions in SAP HANAare the read only function that means we cannot perform any DDL and DML(insert update and delete) operation inside the body of the function.
