[QUOTE][i]Originally posted by marist89 [/i]
[B]You can't use ORDER BY in a view. [/B][/QUOTE]

You can as of Oracle 8.1

HTH,