SQL: Updateable select-statement

["Titus Kruse" <t_kruse@xxxxxxxxx>]

Hi!

I want to submit an updateable query ordered by some colums. Maybe something
like this SQL-statement:

SELECT * FROM file ORDER BY column1, coumnl2 FOR UPDATE

I need it for an updateable restultset in my Java-client. The user can
display an ordered list of some records an he can pick one of these to make
some updates. Any ideas how to do this or isn't it possible to make such a
query?

Titus