17.00 - Example: Using FunctionsV - Teradata Database

Teradata Vantage™ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K

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