OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » Calculation (Oracle 10G, Windows 2012R2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Calculation [message #677560]

Thu, 26 September 2019 05:57

hissam78
Messages: 193
Registered: August 2011
Location: PAKISTAN

Senior Member

Dear All,
we have two tables

T1 table having 1 column COL1 varchar2(100), Value of COL1 = :C1+:C2
T2 table having 3 columns A1 Number, C1 Number, C2 Number.

Now the scenario is,

we will enter value in C1 Column= 20 and C2 Column= 30 in Table T2,
Now we need to return 50 in COlumn A1 in T2 Table, because in T1 we have C1+C2, if in Table T1 COL1 having Value :C1*:C2, so value will return 20*30 = 600 in A1 COlumn in table T2.

somebody can help me, how to define the procedure please??

Thankful,

Report message to a moderator

[Message index]

		Calculation By: hissam78 on Thu, 26 September 2019 05:57
		Re: Calculation By: Solomon Yakobson on Thu, 26 September 2019 06:32
		Re: Calculation By: hissam78 on Thu, 26 September 2019 06:40
		Re: Calculation By: EdStevens on Thu, 26 September 2019 06:55
		Re: Calculation By: hissam78 on Thu, 26 September 2019 07:08
		Re: Calculation By: BlackSwan on Thu, 26 September 2019 08:22
		Re: Calculation By: cookiemonster on Thu, 26 September 2019 08:36
		Re: Calculation By: Solomon Yakobson on Thu, 26 September 2019 09:38
		Re: Calculation By: Solomon Yakobson on Thu, 26 September 2019 09:57
		Re: Calculation By: Solomon Yakobson on Thu, 26 September 2019 10:10
		Re: Calculation By: hissam78 on Fri, 04 October 2019 05:59
		Re: Calculation By: Michel Cadot on Fri, 04 October 2019 07:23
		Re: Calculation By: hissam78 on Sat, 05 October 2019 06:52
		Re: Calculation By: hissam78 on Fri, 27 September 2019 04:55

Previous Topic:	ORA-29279: SMTP permanent error: 550 domain.
Next Topic:	display Old value and new value as per date in single row

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 10 05:05:05 CDT 2024