need an ordered view

From: David Zlotchenko 1 <zlotchen_at_voyager.rtd.utk.edu>
Date: 19 Oct 1999 18:20:42 GMT
Message-ID: <7uicpq$q88$1@gaia.ns.utk.edu>

I need to provide a customer with an easy way to quare a database
that consist of couple dozen tables, mainly lookup tables for internal codes.

To view data without codes, I create series of views. In addition, there are some common queries that will be performed.
SQL sysntax for the query is complex and order by clause with four fields in particular order is essential. I would like to be able to email client a short SQL statement they can execute
to run the query. I relalise that I can store the statement in a
procedure and have them do "exec procname" in sqlplus. But I'd rather have a view that can be queried by select * from myview. However, I can't create a view with order by clause. The Oracle 8 book aknowleges this and suggests that in some cases
group by can have the same result (that is if uniquiness is inforced).

What is the reason for not having views with order by? Can I circumvent it by having an in-line table? What will be the syntax?

Thanks in advance. David.
--
--

David Zlotchenko
E-mail: zlotchen_at_cs.utk.edu
WWW: http://www.oars.utk.edu/~zlotchen Received on Tue Oct 19 1999 - 13:20:42 CDT