Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

generate_series() function

User_1871Apr 29 2022 — edited Apr 29 2022

Could Oracle create an OOTB generate_series() function? https://www.citusdata.com/blog/2018/03/14/fun-with-sql-generate-sql/
Example: https://stackoverflow.com/questions/72059481/generate-rows-from-string-of-numbers. I can't easily solve that problem -- without making things complicated with CROSS JOINS or CONNECT BY. Having an OOTB generate_series() function would make things simpler.

Added on Apr 29 2022

#active, #general-database-discussions-ideas

3 comments

2,833 views