You cannot create view with order by clause. Oracle does not support this.