Sorted list

From: <dushyantmp_at_my-dejanews.com>
Date: Thu, 20 May 1999 04:34:35 GMT
Message-ID: <7i03cr$7em$1@nnrp1.deja.com>

Hi,

I have an application which has to retrieve records from two tables by a Join Query and list 15 records at a time sorted by a field in the table.
Now I have a VIEW with the Join Query from the tables and Iam retrieving 15 records by selecting from the view using ROWCOUNT. I could not use ORDER BY clause in the CREATE VIEW statement(ORACLE doesn't support this) and hence I could not Sort the records. I also could not use ORDER BY clause while selecting from the View as ROWCOUNT and ORDER BY in a Select statement won't go together.

Is there any other way to do this? My application is in Java talking to a Oracle Database (8.0.4) thru JDBC.

Any help in this regard is greatly appreciated.

Thanx in Advance,
Dushyant.

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Wed May 19 1999 - 23:34:35 CDT