Skip to Main Content
Forums

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!

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.

Table- From and To - BETWEEN operator- View to bring all records between from and to

Rajesh234Jun 28 2019 — edited Jun 28 2019

I have a table  TABLE1 where i have 2 columns ValueFrom and ValTo with SIGN option is BT. Now i need to design a View having one column which constitutes of only column.

TABLE1:

SETNAME SIGN OPTION VALFROM VALTO

ABC            I             BT      500700      500710

VIEW1

COLUMN1

500700

500701

500702

500703

500704

500705

500706

500707

500708

500709

500710

Comments

Post Details

Added on Jun 28 2019
#plsql, #procedure, #select, #sql-developer
4 comments
136 views