I would like to know, in Teradata, does it allow single quotes for numeric datatype (int or decimal)?
I have tried TD using quotes. It works. but one of my friend is facing issue when using single quotes.
create table lavendar.alpha(eno integer,salary decimal(12,2));
a "quoted numeric" is not numeric it's a string which is automatically casted by the Parsing Engine to the appropriate data type. Like '2013-06-07' is not a date, it's a string but when inserted into a DATE column it will be automatically casted.
What "issue" did your friend have, was there an error, which error message?