Want to display multiple rows and columns using pass through parameters in dual table

Hi,

I Want to display multiple rows and columns using pass through parameters in dual table.

if I run this query SELECT :ITEM AS ITEM, :ITEM_ID AS ITEM_ID FROM DUAL;  I have to two enter parameter corresponding to ITEM,ITEM_ID.

For instance, if I pass the parameter  ITEM = Milk , ITEM_ID = 1235 .. the table showing like below:

ITEM    ITEM_ID

Item 1     1235

   

My aims to pass multiple data to the parameter corresponding to ITEM,ITEM_ID and would like display multiple rows shown below:

ITEM    ITEM_ID

Item 1     1235

Item 1     1236

Item 1     1237

Item 1     1238

Item 1     1239

I would be really grateful, if any one advise me to solve my expected solution.