Re: Sql problem

Zsolt,

In Oracle9i, you might be able to make use of the new WITH syntax:

      SQL> with xxx as
        2     (select 1+2 calc from dual)
        3  select calc*2 from xxx;

          CALC*2
      ----------
               6

It might cut down on typographic errors (if not syntax complexity) from repeatedly retyping the same complex formula...

Hope this helps...

-Tim

> Hi,
>
>
> The following select does not work, I get ORA-00904 error
> message that the AgentShare column does not exists.
> It would be painful to write down every calculation many
> times because I can't make a reference to a previous
> calculated colunm.
> Select t.*,t.RowId
>
> , CONTR_ROWS_MG - CONTR_ROWS_GROSS_RECEIVED OutStanding
> , CONTRACT_SALESAGENT_PERCENTAGE *
> CONTR_ROWS_GROSS_RECEIVED / 100 AgentShare
> ,CONTRACT_SHARE_FIXED OtherShareFixed
> ,CONTRACT_SHARE_PERCENTAGE * CONTR_ROWS_GROSS_RECEIVED
> /100 OtherSharePercentage
>
> ,AgentShare *2
>
>
> From Contract_Rows T,Contract
>
> Where Contract.Contract_Unique =
> t.contr_rows_contract_unique
>
> Thank you in advance
>
> Zsolt Csillag,
> Hungary
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net --
> Author: Zsolt Csillag
> INET: info_at_starsoft.hu
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com San Diego, California --
> Mailing list and web hosting services
> ----------------------------------------------------------
> ----------- To REMOVE yourself from this mailing list,
> send an E-Mail message to: ListGuru_at_fatcity.com (note
> EXACT spelling of 'ListGuru') and in the message BODY,
> include a line containing: UNSUB ORACLE-L (or the name of
> mailing list you want to be removed from). You may also
> send the HELP command for other information (like
> subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tim Gorman
  INET: tim_at_sagelogix.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).