Oracle Reports (MOSC)

MOSC Banner

about passing multiple value in a parameter

edited Jun 21, 2018 3:26PM in Oracle Reports (MOSC) 5 commentsAnswered
  https://docs.google.com/open?id=0B0dx7wf68mD0eDVFblBUUTl2ZGs 

Hi all, 

i want to pass multiple value using , to separate them 1,2,3....

here is my query
SELECT DISTINCT 
oh.header_id
,oh.org_id
,to_char(oh.ordered_date,'DD-MON-YYYY') d_date
,to_char(oh.ordered_date+31,'DD-MON-YYYY') d_validity
,oh.ship_to_org_id
,oh.invoice_to_org_id
,oh.cust_po_number d_po_num
,rcust.customer_id AS customer_id
,oh.order_number d_salesorder_no
,oh.cust_po_number d_project
,oh.attribute1 second_addr
,oh.attribute2 remark1
,oh.attribute3 remark2
,substr(oh.transactional_curr_code,1,3) as currency

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center