Code:
create or replace view PERC_TAB_USE (STATION, ID, USE, UL_ID, AREA_POND, PERCENT)
as
select a.STATION, ID, USE, UL_ID, AREA_POND, ROUND(AREA/(b.AREA_TOT+c.AREA_TOT2)*100,2) PERCENT
from
(
  select STATION, ID, USE, UL_ID, AREA_POND,sum(AREA_POND) AREA
  from TAB_USE
  GROUP BY STATION, ID, USE, UL_ID, AREA_POND
) a,
(
  select STATION, sum(AREA_POND) AREA_TOT
  from TAB_USE
  group by STATION
) b,
(
  select STATION, sum(AREA_POND) AREA_TOT2
  from TAB_USE
  where USE IN ('ALG','COMM','TRA', 'SP', 'INF')
  group by STATION
) c
where a.station=b.station
and a.station=c.station