SQL & PL/SQL

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!

How to convert RANGE_FROM to RANGE_TO to individual records

User_7JIQMSep 8 2022 — edited Sep 8 2022

I have a table that specifies a range of codes by two columns: range_from and range_to.
range_from range_to
1000 ............. 1003
What I want a query to do is list the individual codes in that range:
1000
1001
1002
1003
Picture provided to help with clarity:

Added on Sep 8 2022

5 comments

425 views

2 mentions