Replace the string using REGEXP_REPLACE function in Teradata
REGEXP_REPLACE function in Teradata REGEXP_REPLACE is one of the regular expression function in Teradata. It is used to replace the
Continue readingCategory: Teradata
Pivot function in Teradata with examples
PIVOT in Teradata Pivot function is used for transforming rows into columns in Teradata. It allows us to aggregate and
Continue readingGrant Select access to table in Teradata
Grant in Teradata Grant statement is used to provide the privileges (permissions) such as SELECT,INSERT,UPDATE on a table to user.
Continue readingAlter table DROP column in Teradata
Drop a column in a table in Teradata We can use ALTER TABLE command to drop a column from an
Continue readingHow to get the current date in Teradata with examples
Current Date in Teradata In Teradata, we can fetch the current date using either CURRENT_DATE or DATE in the Select
Continue readingHow to calculate the query execution time in Teradata
DBC Tables in Teradata – Data dictionary of Teradata Teradata stores the log of each and every SQL query data
Continue readingHow to Create or Drop the Secondary Index in Teradata
Secondary index in Teradata Secondary index is an alternate path to the rows of a table in Teradata. It is
Continue readingExtract function in Teradata with examples
Extract function in Teradata EXTRACT function is used to get the Year,Month or Day from a date. Also it is
Continue readingConcatenation operator and Concat function in Teradata with examples
Teradata allows us to concatenate the string or numeric values using either concatenation operator or concat() function. Concatenation operator (||)
Continue readingHow to write nested Case statement in Teradata?
Case Statement in Teradata CASE statement is a conditional expression that used to evaluate the conditions or perform the equality
Continue reading
