Oracle Query - column group

[SamBiju]

I have a query to retrieve few columns from different tables.

select distinct sso.sales_order_nb, sso.shipment_id, ssh.tracking_nb, sta_container.box_number, ste.sales_organization_code, ssd.compaq_part_nb, md.product_marketing_description
from sta_shipment_order sso, sta_shipment_err ste, sta_container, sta_shipment_header ssh, sta_shipment_detail ssd, material_description md .................

In this query when all the columns are same except ssd.compaq_part_nb, md.product_marketing_description , obviously I will be getting multiple rows .

But I want to make it in one row when only product_marketing_description is different by separating the descriptions with some '/ '

Please help me to get it done.

Thanks in advance

[amitpatel66]

I have a query to retrieve few columns from different tables.

select distinct sso.sales_order_nb, sso.shipment_id, ssh.tracking_nb, sta_container.box_number, ste.sales_organization_code, ssd.compaq_part_nb, md.product_marketing_description
from sta_shipment_order sso, sta_shipment_err ste, sta_container, sta_shipment_header ssh, sta_shipment_detail ssd, material_description md .................

In this query when all the columns are same except ssd.compaq_part_nb, md.product_marketing_description , obviously I will be getting multiple rows .

But I want to make it in one row when only product_marketing_description is different by separating the descriptions with some '/ '

Please help me to get it done.

Thanks in advance

You can achieve this by using a PLSQL Block.
Write a function which combines the product_marketing_description with a "\" and return that value.

Call this function from the SELECT statement

[SamBiju]

You can achieve this by using a PLSQL Block.
Write a function which combines the product_marketing_description with a "\" and return that value.

Call this function from the SELECT statement

Hi Amit,

This is already a PL/SQL block. The query part I have mentioned is actaually in the cursor .Is it possible to do something in PL/SQl block itself without going for another fuction/Procedure

The result should be send as a report

Thanks

[amitpatel66]

Hi Amit,

This is already a PL/SQL block. The query part I have mentioned is actaually in the cursor .Is it possible to do something in PL/SQl block itself without going for another fuction/Procedure

The result should be send as a report

Thanks

Can you please POST your plsql block for my reference so that we could give you different options of achieving the functionality.
What kind of report is required? a flat file?

[amitpatel66]

Check out if you could use one more cursor passing ID to that and selecting the market products.

Call that cursor by pasing the ID, get all the products, and have a variable that stores the product values with delimited "\".Use that variable in your report.