Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 8.0.5.0.0 in-line view and Order By

Re: Oracle 8.0.5.0.0 in-line view and Order By

From: <mike.allen_at_snowvalley.com>
Date: Thu, 05 Aug 1999 11:16:03 GMT
Message-ID: <7obrpf$3d4$1@nnrp1.deja.com>


In article <933847416.12400.0.nnrp-01.9e984b29_at_news.demon.co.uk>,   "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:
>
> ORDER BY in in-line views is a feature of 8.1, not 8.0
>
> The syntax TABLE(.... is also 8.1, but this is just
> a minor detail, the 8.0 version is THE(.....)
>
> --
>
> Jonathan Lewis

Yes, thanks John, I discovered that about 5 minutes ago, so I was going to do a follow up post explaining what a wally I've been. Looks like nasty hack time then. Anybody have a least nasty hack? I've seen a couple of variations.
Making an app compatible with 3 totally different databases is not fun.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Aug 05 1999 - 06:16:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US