Can we use ORDER BY in view?

Can we use ORDER BY clause in view's definition:

CREATE OR REPLACE VIEW a_v as
select * from a order by 1;

According to Oracle's Student Guide, this is not allowed. But, by my testing with 9iR2, it is allowed. So what is the exact rule? Received on Mon Feb 28 2005 - 06:20:42 CST