Can we use ORDER BY in view?

DA Morgan · *nix forums Guru Joined: 06 Mar 2005 Posts: 1042

Mark D Powell wrote:

DA Morgan · *nix forums Guru Joined: 06 Mar 2005 Posts: 1042

dd wrote:

Mark D Powell · *nix forums Guru Joined: 23 Apr 2005 Posts: 701

What version of whose student guide do you have? Order by clauses in
views were not supported back in version 7, but this restriction has
been lifted. I do not remember the exact version when Oracle lifted
this restriction; it may have been with one of the 8.1 versions.
However, order by clauses should appear in views only where necessary
to create the correct result set. In the majority of cases the final
set ordering should be specified with the query on the view.

Someone else might remember the version where this changed but with 9.2
it is legal.

HTH -- Mark D Powell --

dd · *nix forums beginner Joined: 08 Jun 2005 Posts: 14

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?

Google