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 [...]

Click here to read more

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 [...]

Click here to read more