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 readingREGEXP_REPLACE function in Teradata REGEXP_REPLACE is one of the regular expression function in Teradata. It is used to replace the
Continue readingPIVOT in Teradata Pivot function is used for transforming rows into columns in Teradata. It allows us to aggregate and
Continue readingGrant in Teradata Grant statement is used to provide the privileges (permissions) such as SELECT,INSERT,UPDATE on a table to user.
Continue readingDrop a column in a table in Teradata We can use ALTER TABLE command to drop a column from an
Continue readingCurrent Date in Teradata In Teradata, we can fetch the current date using either CURRENT_DATE or DATE in the Select
Continue readingDBC Tables in Teradata – Data dictionary of Teradata Teradata stores the log of each and every SQL query data
Continue readingSecondary index in Teradata Secondary index is an alternate path to the rows of a table in Teradata. It is
Continue readingExtract function in Teradata EXTRACT function is used to get the Year,Month or Day from a date. Also it is
Continue readingTeradata allows us to concatenate the string or numeric values using either concatenation operator or concat() function. Concatenation operator (||)
Continue readingCase Statement in Teradata CASE statement is a conditional expression that used to evaluate the conditions or perform the equality
Continue reading