Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Please ask technical questions in the appropriate category. Thank you!

Query for updating multiple columns of single record

BommiMay 7 2024

Hi Experts,

We are creating a report that generates the csv file with ABC Classification of items. As of now, we generated report with below format. Here, Classification is done at BU Level(Even though we are showing the data at Org level. Which means showing same Class name for all the Orgs under that BU). Here, we are using ATRIBUTE1 for US BU and ATTRIBUTE2 for DE BU. Till this step I am able to achieve.

Now, the requirement got changes a little bit. Now, they want to show one more record for each item under the parent Org(P_ORG) where ATTRIBUTE1 and ATTRIBUTE2 has to show BU level class names as below.

Can anyone please help me on how to achieve this.

Thanks in Advance,
Bommi

Comments
Post Details
Added on May 7 2024
8 comments
218 views