From: postbus@sybrandb.demon.nl (Sybrand Bakker)
Newsgroups: comp.databases.oracle
Subject: Re: sql: results returned in order
Date: 10 Oct 2001 05:19:07 -0700
Organization: http://groups.google.com/
Lines: 22
Message-ID: <a20d28ee.0110100419.3aa3c9dc@posting.google.com>
References: <3bc3cff9$0$580$afc38c87@news.optusnet.com.au>
NNTP-Posting-Host: 144.44.150.150
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1002716348 4236 127.0.0.1 (10 Oct 2001 12:19:08 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 10 Oct 2001 12:19:08 GMT


Rob Hazlewood <rob@moofed.com> wrote in message news:<3bc3cff9$0$580$afc38c87@news.optusnet.com.au>...
> Hi,
> I have a small section of a program that lists the users that are using a 
> java servlet, which is using oracle 8i with the thin client driver
> 
> I have been using the following command:
> SELECT id,name FROM users
> and then arranging into order locally (decending id number).
> 
> is there a way to get the resultset to retreive results in arranged order?
> 
> thanks
> Rob

Just use
select id, name from users order by id
and start to *learn* sql *now*.

Regards,

Sybrand Bakker
Senior Oracle DBA