Re: PL/SQL Problem

From: Lehner Eveline <a9325237_at_unet.univie.ac.at>
Date: Tue, 21 Apr 1998 10:14:52 +0200
Message-ID: <353C557C.D613126@unet.univie.ac.at>

> Try
>
> Create VIEW.... As Select ..... From Table ...... Where.....Order By..
>
> Then Query the view....
>
> Hope it helps,
> John Greco
> Oracle DBA
> Email to john.greco_at_dot.state.mn.us

In Create View- or Create Table-Statement you just can use Subselects after AS SELECT and subselect don't include ORDER BY. That's the problem. But, thanks for the answer.
Eveline Lehner
University Vienna, Austria Received on Tue Apr 21 1998 - 03:14:52 CDT