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 ;

SELECT * FROM CATEGORY_DETAIL;

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