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

 

Teradata:

=======

?

 

Note : without using ant set operators

 

Thanks ,

saikrishna.k

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.

Cheers.

Carlos.

You must sign in to leave a comment.