Oracle 11g Release 2

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

CREATE TABLE TABLE_WITH_ATTRS AS
  SELECT 1 AS ID_TABLE_WITH_ATTRS,
         10 AS ATTRIBUTE10, NULL AS ATTRIBUTE11, 12 AS ATTRIBUTE12 FROM DUAL UNION ALL
  SELECT 2 AS ID_TABLE_WITH_ATTRS,
         100 AS ATTRIBUTE10, 110 AS ATTRIBUTE11, 120 AS ATTRIBUTE12 FROM DUAL UNION ALL
  SELECT 3 AS ID_TABLE_WITH_ATTRS,
         1000 AS ATTRIBUTE10, 1100 AS ATTRIBUTE11, NULL AS ATTRIBUTE12 FROM DUAL UNION ALL
  SELECT 4 AS ID_TABLE_WITH_ATTRS,
         10000 AS ATTRIBUTE10, 11000 AS ATTRIBUTE11, 12000 AS ATTRIBUTE12 FROM DUAL UNION ALL
  SELECT 5 AS ID_TABLE_WITH_ATTRS,
         NULL AS ATTRIBUTE10, 110000 AS ATTRIBUTE11, 120000 AS ATTRIBUTE12 FROM DUAL;
5 rows affected

SELECT *
  FROM TABLE_WITH_ATTRS;


ID_TABLE_WITH_ATTRS
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12


1
10
null
12

2
100
110
120

3
1000
1100
null

4
10000
11000
12000

5
null
110000
120000


CREATE TABLE ATTR_TABLE AS
  SELECT ID_ATTR, ID_TABLE_WITH_ATTRS, ATTR
    FROM (SELECT ((ID_TABLE_WITH_ATTRS-1)*100)+1 AS ID_ATTR, ID_TABLE_WITH_ATTRS, ATTRIBUTE10 AS ATTR FROM TABLE_WITH_ATTRS UNION ALL
          SELECT ((ID_TABLE_WITH_ATTRS-1)*100)+2, ID_TABLE_WITH_ATTRS, ATTRIBUTE11 FROM TABLE_WITH_ATTRS UNION ALL
          SELECT ((ID_TABLE_WITH_ATTRS-1)*100)+3, ID_TABLE_WITH_ATTRS, ATTRIBUTE12 FROM TABLE_WITH_ATTRS);
15 rows affected

SELECT *
  FROM ATTR_TABLE
  ORDER BY ID_ATTR


ID_ATTR
ID_TABLE_WITH_ATTRS
ATTR


1
1
10

2
1
null

3
1
12

101
2
100

102
2
110

103
2
120

201
3
1000

202
3
1100

203
3
null

301
4
10000

302
4
11000

303
4
12000

401
5
null

402
5
110000

403
5
120000


SELECT *
  FROM ATTR_TABLE
  WHERE ATTR IS NOT NULL
  ORDER BY ID_ATTR


ID_ATTR
ID_TABLE_WITH_ATTRS
ATTR


1
1
10

3
1
12

101
2
100

102
2
110

103
2
120

201
3
1000

202
3
1100

301
4
10000

302
4
11000

303
4
12000

402
5
110000

403
5
120000

ID_TABLE_WITH_ATTRS	ATTRIBUTE10	ATTRIBUTE11	ATTRIBUTE12
1	10	null	12
2	100	110	120
3	1000	1100	null
4	10000	11000	12000
5	null	110000	120000