Using Teradata Vantage™ - SQL Functions, Expressions, and Predicates
This document is primarily for Teradata Vantage™ application programmers and end users, but it might also be helpful to those who design and maintain Teradata Vantage.
Why Would I Use this Content?
To learn about Teradata Vantage SQL functions, operators, expressions, and predicates.
How Do I Use this Content?
To learn the purpose and syntax of Teradata Vantage SQL functions, operators, expressions, and predicates and see examples and references to related information.
How Do I Get Started?
If you are unfamiliar with Teradata Vantage, read Teradata Vantage™ - Database Introduction, B035-1091.
If you are familiar with Teradata Vantage, start with Functions, Operators, Expressions, and Predicates.
References to Other Relevant Content
| ARRAY/VARRAY functions, operators, expressions, and methods | Teradata Vantage™ - Data Types and Literals, B035-1143 |
| BLOB and CLOB functions | Teradata Vantage™ - Data Types and Literals, B035-1143 |
| Calendar and business calendar functions | Teradata Vantage™ - SQL Date and Time Functions and Expressions, B035-1211 |
| The CAST expression and data type conversion functions | Teradata Vantage™ - Data Types and Literals, B035-1143 |
| Compression/decompression functions | Teradata Vantage™ - SQL Operators and User-Defined Functions, B035-1210 |
| DATASET functions and methods | Teradata Vantage™ - DATASET Data Type, B035-1198 |
| DateTime and interval functions and expressions | Teradata Vantage™ - SQL Date and Time Functions and Expressions, B035-1211 |
| Export width procedures (manage the amount of data exported to client applications) | Teradata Vantage™ - SQL Operators and User-Defined Functions, B035-1210 |
| File system information macros and functions (gain information on specific data blocks) | Teradata Vantage™ - SQL Operators and User-Defined Functions, B035-1210 |
| Geospatial functions and methods | Teradata Vantage™ - Geospatial Data Types, B035-1181 |
| JSON functions and methods | Teradata Vantage™ - JSON Data Type, B035-1150 |
| Map functions, macros, and procedures (optimize the placement of tables across AMPs) | Teradata Vantage™ - SQL Operators and User-Defined Functions, B035-1210 |
| Period functions and operators | Teradata Vantage™ - SQL Date and Time Functions and Expressions, B035-1211 |
| Script installation procedures | Teradata Vantage™ - SQL Operators and User-Defined Functions, B035-1210 |
| SET operators (INTERSECT, MINUS/EXCEPT, UNION) | Teradata Vantage™ - SQL Data Manipulation Language, B035-1146 |
| Table operators | Teradata Vantage™ - SQL Operators and User-Defined Functions, B035-1210 |
User-defined type expressions and these UDFs supplied by Teradata:
|
Teradata Vantage™ - SQL Operators and User-Defined Functions, B035-1210 |
| XML functions and methods | Teradata Vantage™ - XML Data Type, B035-1140 |
| Analytic functions specifically for analyzing data | Teradata Vantage™ - Analytics Database Analytic Functions, B035-1206 |