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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Order of population of formula columns in Reports 6i

Re: Order of population of formula columns in Reports 6i

From: Luis Cabral <luiscabral99_at_ig.com.br>
Date: 25 Jan 2002 11:01:57 -0800
Message-ID: <c9ff1799.0201251101.4269e469@posting.google.com>


Hi

Reports has such a 'intelligence' to evaluate the formula columns in the proper order... You do not have to worry about it.

And if two formula columns references each other (circular dependency) you will get a REP-1241.

Luis Cabral

"Noah Arc" <bowed_zombie_drone_at_spam.begone.zombie.co.uk> wrote in message news:<_Wb38.309$PT3.241548_at_monolith.news.easynet.net>...
> Hello,
>
> Can the order of formula column population be predicted? I have a
> formula which returns a LONG column as a VARCHAR. There are spurious
> extra spaces at the end of the data within this long column, so I
> was thinking of RTRIMming the formula column in another formula
> column. However, to achieve this, I need to ensure the formula which
> returns the LONG fires first before the second one TRIMs it.
>
> Is this possible? Or is there a more elegant way of getting around
> this problem?
>
> Any help would be greatly appreciated.
>
> Thanks.
Received on Fri Jan 25 2002 - 13:01:57 CST

Original text of this message

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