Skip to Main Content
Forums

Oracle Forms

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!

Oracle Forms Get an Input From user and Display results based on the Input

user10120962Jun 17 2015 — edited Jun 19 2015

Hi

I've a table like below

Product Code Start_SN End_SN

0001                    100     1000

0002                    1001     2000

I need to create a form which takes the Input as serial number and returns the Product Code which falls in that range.

Some how need to display the results of the following query based on user input "inp_SN"

select Product_code,start_SN, End_SN from table where inp_SN between Start_SN and end_SN

I'm new to forms and dont know how to do this?

Thanks in Advance

Sri
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 17 2015
Added on Jun 17 2015
#forms, #moved-from-devops
4 comments
1,041 views