Re: Sorting order in Base Table

From: Van Nieuwenhuyse <van_nieuwenhuyse_luytens_at_online.be>
Date: Thu, 28 Jan 1999 21:18:56 +0100
Message-ID: <78qgtg$stb$1_at_trex.antw.online.be>

[Quoted] try select decode(a,'P',1,'S',2,'O',3) aliasname,a,b

     from table_a
     order by 1;

if you don't need the result of 'aliasname' on the screen, put it on the null-canvas.

River heeft geschreven in bericht <36B067C2.4B04FC7E_at_vol.net>...
>eg. select a,b
> from table_a
> order by decode(a,'P',1,'S',2,'O',3)
>
>In Forms4.5. How to use base table block to do the above sql?
>I've tried putting the order by clause at the 'order' property of the
>block at design time and runtime,
>but to no avail.
>
>Any advice,
>
>River
>novice DBA
>
>
Received on Thu Jan 28 1999 - 21:18:56 CET