I am new to Teradata.
Please let me know how to display the single row into multiple time.
In oracle :
saelect * from table connect by level<4
Note : without using ant set operators
Take a look at 'WITH RECURSIVE' in the docco.
'connect by' is a proprietary Oracle syntax. The WITH RECURSIVE is the ANSI syntax, which is used from Oracle 11gR2 onwards, btw.