Urgent: Why is there an error in the statement when there is UNION when creating a view?

yang168

create or replace view v_all_limit
as
(


 select * from all_limit
 union
  select * from all_limit2

)

gloveheart

create or replace view v_all_limit
as



 select * from all_limit
 union
  select * from all_limit2