Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Multiple column pivot

New RootsAug 23 2022

Hi All,
We have table which is having below records.

DROP TABLE CATEGORY_MASTER;
/
CREATE TABLE CATEGORY_MASTER
(cat_1 VARCHAR2(10)
,cat_2 VARCHAR2(10)
,cat_3 VARCHAR2(10)
,cat_4 VARCHAR2(10)
,cat_5 VARCHAR2(10));

INSERT INTO CATEGORY_MASTER VALUES('CD','BOOK','APP','ELE','GEN');
/
COMMIT;

DROP TABLE CATEGORY_DETAIL;
/

CREATE TABLE CATEGORY_DETAIL
(category VARCHAR2(10),
category_desc VARCHAR2(30));
/

INSERT INTO CATEGORY_DETAIL
VALUES('CD','COMPACT DISK');

INSERT INTO CATEGORY_DETAIL
VALUES('BOOK','THRILLER BOOKS');

INSERT INTO CATEGORY_DETAIL
VALUES('APP','CONSUMER APPLICATION');

INSERT INTO CATEGORY_DETAIL
VALUES('ELE','ELECTRONICS');

INSERT INTO CATEGORY_DETAIL
VALUES('GEN','GENERAL');
/

SELECT *FROM
CATEGORY_MASTER ;
image.png

SELECT * FROM CATEGORY_DETAIL;
image.png

Below is my required output. In same single row the output records expected.
This table exists for long time.

image.png

This post has been answered by Frank Kulash on Aug 23 2022
Jump to Answer
Comments
Post Details
Added on Aug 23 2022
6 comments
6,165 views