Sorting order in Base Table
From: River <wychan_at_vol.net>
Date: Thu, 28 Jan 1999 21:36:03 +0800
Message-ID: <36B067C2.4B04FC7E_at_vol.net>
[Quoted] eg. select a,b
Date: Thu, 28 Jan 1999 21:36:03 +0800
Message-ID: <36B067C2.4B04FC7E_at_vol.net>
[Quoted] eg. select a,b
[Quoted] 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 - 14:36:03 CET