Re: How do you order by rows in a view?
From: DavidJRoth <davidjroth_at_aol.com>
Date: 17 Dec 1994 11:50:02 -0500
Message-ID: <3cv4rq$8dl_at_newsbf01.news.aol.com>
Date: 17 Dec 1994 11:50:02 -0500
Message-ID: <3cv4rq$8dl_at_newsbf01.news.aol.com>
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.