17.10 - Example: Using FunctionsV - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Programming Reference
Publication ID
B035-1092-171K
Language
English (United States)

The following SELECT statement displays information about the overloaded functions named 'concat' in 'dba' database:

SELECT SpecificName, NumParameters, ParameterDataTypes 
FROM FunctionsV 
WHERE DatabaseName = 'dba' AND FunctionName = 'concat' 
ORDER BY 1,2,3;

Result:

SpecificName  NumParameters ParameterDataType
------------- ------------- -----------------
concat                    2 CFCF
concat_3                  3 CFCFCF
concat_4                  4 CFCFCFCF