I have been migrating from Oracle to Teradata and would like your help to convert the following Oracle SQL code to Teradata SQL
this query simply returns a list of integers between 1 and 10, you can easily get the same result with:
select day_of_calendar as count1
where day_of_calendar between 1 and 10;
More complex queries implemented with CONNECT BY can be rewritten using Standard SQL's WITH RECURSIVE syntax.