create a module from a specific select statement [message #635922] |
Mon, 13 April 2015 02:01 |
|
amjad_alahdal
Messages: 102 Registered: October 2013 Location: Saudi Arabia
|
Senior Member |
|
|
Hello guys,
I have two tables
A and B.
The Query is
__________________________________________________________
select A.e_no, A.e_name, A.d_no, A.e_amount, B.D_date
from A,B
where A.d_no = B.d_no
and e_no = :My_item
___________________________________________________
This Query always retrieve multiple records. I want the return values to be in an item for example ITEM60.
As well, My_item is an item in my block. As well, the query is executed inside a button.
This block should not modify any data from my database. I am using Oracle Developer 6i
plz, help
|
|
|
|
|