ReadVitamin

Usage of Macro in Teradata

A macro is created to execute a single or a set of SQL statements in a single execution. Each time the macro is run all of the SQL statements present inside the macro are executed and results are returned after the end of all the SQL present inside the macro. Why do we need a macro? If there is a set of frequently used SQL statement which are being repeatedly executed, this set of SQL statement [+]

Creating Column Aliases in Teradata

When you want the column name of the table to appear differently in your SQL query, just to make sure that you too can do some magic, you can use aliases. Though aliases can also be created for various database objects like tables, views, stored procedures and macros, it is the column aliases that are more frequently used. Aliases are also referred as correlation name. Except for having a better readability, column aliases can also [+]