Teradata Stored Procedure A stored procedure contains a set of SQL statements and procedural statements. They consist of a set of control…
Tag:
teradata architecture
-
-
Teradata Join Strategies Teradata Join Strategies are utilized by the optimizer to choose the minimum cost plan and better performance. The strategy…
-
Teradata String Manipulation Teradata provides several functions to manipulate the strings. These functions are compatible with the ANSI standard. Teradata String Functions…
-
Teradata Joins Join is used to combine records from more than one table. Tables are joined based on the common columns and…
-
Teradata SubQueries The Teradata SubQuery returns records from one table based on the values from another table. It is a SELECT query…
-
Teradata BTEQ Teradata BTEQ stands for Basic Teradata Query. It is a command-driven utility that enables users to interact with one or…
-
Teradata Logical and Conditional Operators Teradata supports the following logical and conditional operators. These operators are used to perform comparisons and combine…
-
Teradata Substring The Teradata SUBSTRING or SUBSTR function is one of the Teradata string functions, and it is used to cut a…
-
Teradata Built-In Functions Teradata provides built-in functions, which are extensions to SQL. The Built-in functions return information about the system. Built-in functions…
-
Teradata Macros Macro is a set of SQL statements that are stored and executed by calling the Macro name. The definition of…