16.20 - Example: Invoking an SQL UDF Within a View Definition - Teradata Database - Teradata Vantage NewSQL Engine

This example invokes the SQL UDF value_expression in the select list of the definition of the view named v1.

     CREATE VIEW v1 (a, b, c) 
       AS SELECT a1, test.value_expression(3,4), c1
          FROM t1 
          WHERE a1 > b1;

The next example invokes the SQL UDF value_expression in the WHERE clause of the view named v2.

     CREATE VIEW v2 (a, b, c) 
       AS SELECT a1, b1, c1 
          FROM t1
          WHERE test.value_expression(b1, c1) > 10;