Re: How do you order by rows in a view?

In article 8dl_at_newsbf01.news.aol.com, davidjroth_at_aol.com (DavidJRoth) writes:
>In article <ALAW.94Dec16081824_at_ap226sun.oracle.com>, alaw_at_oracle.com
>(Alvin Law) writes:
>
>You can do the order by in the query that references the view.
>Hints may work but they are just hints and the optimizer may choose to
>ignore them. In particular, they do not seem to work over SQL*Net.
>Oracle does NOT support Descending indexes. Yes, I know its in the
>syntax. Read the fine print.

AHAHAH!! It doesn't handle descending indices, but it *will* follow an ascending index *backwards* using the appropriate hint!

---
<<MFF>>


-------------------------------------

"Twenty-Five years ago it meant something to be Crazy!"

			-- Charles Manson