Re: Sorting order in Base Table

You will create the following function in the DATABASE:

create or replace function fct_order_by(a varchar2) return number is
n number;
begin
select decode(a,'P',1,'S',2,'O',3)
into n
from dual;
return(n);
end fct_order_by;

Then in form, in the order by property you put: FCT_ORDER_BY(a)
an then, your the hero of the day!!!!!!!!!!!!!!! Good luck!!!!!
In article <36B067C2.4B04FC7E_at_vol.net>,   River <wychan_at_vol.net> wrote:
> 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
>
>

Frank Delisle
Consultant, Eds Québec
e-mail: francois.delisle_at_prosig.qc.ca "Un problème sans solution n'est pas un problème"

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Jan 29 1999 - 23:10:44 CET