All Forums Database
ksaikrishna 26 posts Joined 08/11
14 Apr 2012
How to display each row in a table into multiple times

Hi All,


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


Thanks ,


CarlosAL 512 posts Joined 04/08
16 Apr 2012

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.



You must sign in to leave a comment.