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!

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.

Comments
Post Details
Added on Apr 29 2022
3 comments
3,014 views