I have the following set of data in which prod_no is getting repeated
PR890 1 TAG1
PR890 2 DATE1
PR890 3 SEQ
PR890 4 SERIES
PR240 1 COLS
PR240 2 VALUES
PR240 3 MEASURE
PR240 4 X-axis
PR500 1 FENCE
PR500 2 SIZES
PR500 3 HOPS
PR500 4 Y-axis
Ideally, I would like to have the prod_no appear once, expected output is as follows
I am using database which is legacy and database version is 8i
Table structure and sample data
CREATE TABLE PROD_TAB
(
PROD_NO VARCHAR2(5),
PROD_SEQ NUMBER,
PROD_TEXT VARCHAR2(7)
);
SET DEFINE OFF;
Insert into PROD_TAB
(PROD_NO, PROD_SEQ, PROD_TEXT)
Values
('PR890', 1, 'TAG1');
Insert into PROD_TAB
(PROD_NO, PROD_SEQ, PROD_TEXT)
Values
('PR890', 2, 'DATE1');
Insert into PROD_TAB
(PROD_NO, PROD_SEQ, PROD_TEXT)
Values
('PR890', 3, 'SEQ');
Insert into PROD_TAB
(PROD_NO, PROD_SEQ, PROD_TEXT)
Values
('PR890', 4, 'SERIES');
Insert into PROD_TAB
(PROD_NO, PROD_SEQ, PROD_TEXT)
Values
('PR240', 1, 'COLS');
Insert into PROD_TAB
(PROD_NO, PROD_SEQ, PROD_TEXT)
Values
('PR240', 2, 'VALUES');
Insert into PROD_TAB
(PROD_NO, PROD_SEQ, PROD_TEXT)
Values
('PR240', 3, 'MEASURE');
Insert into PROD_TAB
(PROD_NO, PROD_SEQ, PROD_TEXT)
Values
('PR240', 4, 'X-axis');
Insert into PROD_TAB
(PROD_NO, PROD_SEQ, PROD_TEXT)
Values
('PR500', 1, 'FENCE');
Insert into PROD_TAB
(PROD_NO, PROD_SEQ, PROD_TEXT)
Values
('PR500', 2, 'SIZES');
Insert into PROD_TAB
(PROD_NO, PROD_SEQ, PROD_TEXT)
Values
('PR500', 3, 'HOPS');
Insert into PROD_TAB
(PROD_NO, PROD_SEQ, PROD_TEXT)
Values
('PR500', 4, 'Y-axis');
COMMIT;
@"Solomon Yakobson"