SQL & PL/SQL

1 error has occurred

Your session has timed out.

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.

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

357 views

2 mentions

SQL & PL/SQL

How to convert RANGE_FROM to RANGE_TO to individual records

Comments

Post Details