RE: Math equation in Oracle SQL

  • From: "Adrian Beech" <a.beech@xxxxxxxxxxxxxx>
  • To: <programmingblind@xxxxxxxxxxxxx>
  • Date: Sat, 23 Aug 2008 09:57:33 +1000


You have aliased RP08_R2_RETRO_PAY_SUM as r2 and referenced it as rp2 in the
equation.  The statement seems to be truncated too so I'm not able to
determine if you've done the same with the rp1 reference.  Might I also
suggest you associate a name with the result of the equation as well.



-----Original Message-----
From: programmingblind-bounce@xxxxxxxxxxxxx
[mailto:programmingblind-bounce@xxxxxxxxxxxxx] On Behalf Of Eileen Lafond
Sent: Saturday, 23 August 2008 8:21 AM
To: programmingblind@xxxxxxxxxxxxx
Subject: Math equation in Oracle SQL

I have to divide two fields and put the result in another field.  I am just
starting out with the select statement of the equation itself, but am
getting a strange error message.    I am putting the code and error mesage
here, if someone can assist me.

RP08_R2_RETRO_PAY_SUM r2, rp08_r2_empl
ERROR at line 1:
ORA-00904: "RP2"."RESOURCE_AMOUNT": invalid identifier

Thanks for any help,

Eileen La Fond
Phone (206) 386-0011
e.mail Eileen.LaFond@xxxxxxxxxxx

View the list's information and change your settings at

__________ NOD32 3381 (20080822) Information __________

This message was checked by NOD32 antivirus system.

View the list's information and change your settings at

Other related posts: