RE: Sql problem

From: Stephane Faroult <sfaroult_at_oriolecorp.com>
Date: Thu, 19 Dec 2002 06:39:21 -0800
Message-ID: <F001.0051E1C3.20021219063921@fatcity.com>

('binary' encoding is not supported, stored as-is)
Two possible answers : 42 and inline views.

>----- Original Message -----
>From: Zsolt Csillag <info_at_starsoft.hu>
>To: Multiple recipients of list ORACLE-L
><ORACLE-L_at_fatcity.com>
>Sent: Thu, 19 Dec 2002 05:43:55
>
>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).
>---------------------------------------------------
>------------------

Regards,

Stephane Faroult
Oriole

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroul
  INET: sfaroult_at_oriolecorp.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).

Received on Thu Dec 19 2002 - 08:39:21 CST