Is there any option available in Teradata to set a default value, while initializing a parameterised variable?
In Oracle, we have like
Create or replace procedure sample (firstname varchar(20) DEFAULT NULL, lastname varchar(20) DEFAULT NULL)
--- statement block
If we does not pass value to variable lastname, it will automatically consider NULL as Default value and pass it into procedure. So, there is NO compulsory to pass value.
Is there any option present in Teradata?
You can do that for macros. See this link