Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE table1
(
  my_count  INTEGER,
  my_type   VARCHAR (10),
  count     INTEGER,
  type      VARCHAR (10)
);
begin
INSERT INTO table1 VALUES (1, 'type1', 34, 'type1_bis');
INSERT INTO table1 VALUES (2, 'type2', 45, 'type2_bis');
INSERT INTO table1 VALUES (3, 'type3', 45, 'type3_bis');
INSERT INTO table1 VALUES (4, 'type4', 67, 'type4_bis');
INSERT INTO table1 VALUES (5, 'type5', 78, 'type5_bis');
end;
/
1 rows affected

select * from table1;


MY_COUNT
MY_TYPE
COUNT
TYPE


1
type1
34
type1_bis

2
type2
45
type2_bis

3
type3
45
type3_bis

4
type4
67
type4_bis

5
type5
78
type5_bis

MY_COUNT	MY_TYPE	COUNT	TYPE
1	type1	34	type1_bis
2	type2	45	type2_bis
3	type3	45	type3_bis
4	type4	67	type4_bis
5	type5	78	type5_bis