How to display each row in a table into multiple times

Database
Enthusiast

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

Teradata:

=======

?

Note : without using ant set operators

Thanks ,

saikrishna.k

1 REPLY
Junior Supporter

Re: How to display each row in a table into multiple times

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.

Cheers.

Carlos.