Teiid SQL syntax for oracle LEVEL

[hend.amin]

Hello

Is there an equivalent teiid query to that oracle query ?

(SELECT LEVEL A

         FROM DUAL CONNECT BY 1 = 1)

Regards

Hend

[shawkins]

Teiid supports the more standard recursive common table expression feature WITH Clause · Teiid Documentation which in many instances can be instead of the level/connect by feature.  See Hierarchical and recursive queries in SQL - Wikipedia, the free encyclopedia or other similar discussions.

[hend.amin]

I need to create a query that generates a number sequence ..

[shawkins]

A sequence with recursive common table expressions is more verbose.  With Oracle syntax:

with x (col) as (select 1 as col from dual union all select col + 1 from x where col < 10000) select * from x

Teiid syntax:

with x (col) as (select 1 as col union all select col + 1 from x where col < 10000) select * from x

The where clause controls how far the sequence goes.