SQL> with t as (select 'magazine><><><railway_station' value from dual),
  2       x as (select xmltype('<root>' || replace('<' || value || '>', '>', 'X/>') || '</root>') x from t),
  3       y
  4       as (select extract(x, '/root/*[1]') x1,
  5                  extract(x, '/root/*[2]') x2,
  6                  extract(x, '/root/*[3]') x3,
  7                  extract(x, '/root/*[4]') x4
  8             from x)
  9  select substr(replace(x1, 'X/>'), 2) x1,
 10         substr(replace(x2, 'X/>'), 2) x2,
 11         substr(replace(x3, 'X/>'), 2) x3,
 12         substr(replace(x4, 'X/>'), 2) x4
 13    from y;

X1                   X2                   X3                   X4
-------------------- -------------------- -------------------- --------------------
magazine                                                       railway_station

SQL>