Skip to Main Content

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!

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
4 comments
139 views