Re: ABOUT OPERAND??

From: Heidi Schuerger <schuerger_at_utopia.nrl.navy.mil>
Date: Mon, 26 Jul 1999 11:24:20 -0400
Message-ID: <7nhulm$2cp$1_at_ra.nrl.navy.mil>

declare

  a number := 10;
  b number := 20;
  c number := 30;

  sum number ;
begin
  sum := a+b-c;
--consider this

  dbms_output.enable(1000000);
  dbms_output.put_line (' a+ b -c ='||to_char( a- b +c));
  dbms_output.put_line (' a- b +c ='||to_char( a- b +c));
  dbms_output.put_line ('(a- b)+c ='||to_char((a- b)+c));
  dbms_output.put_line (' a-(b +c)='||to_char( a-(b +c)));

/* +/- have equal precedence and PL/SQL evaluates left-to-right

 10-  20  +30  =  20
(10-  20) +30  =-10+30= 20
 10- (20  +30) = 10 -  0=-40

*/
end operand;

Kanson Ku wrote in message <3798CEA4.2BD883EC_at_cc.nctu.edu.tw>...
>HI ALL
>
>How can I manipulate (A+B-C) in PL/SQL
>A B C are values likes 10 ,20, 30 etc...
>is it SUM=:A+:B-:C or what else
>
>thanks in advance
>
>Kanson
>
Received on Mon Jul 26 1999 - 17:24:20 CEST