Home » SQL & PL/SQL » SQL & PL/SQL » Re: triggers
Re: triggers [message #18677] Sun, 10 February 2002 22:54
Satish Shrikhande
Messages: 167
Registered: October 2001
Senior Member
declare
a number;
begin
a:= trunc(1000/2+0.5);
dbms_output.put_line(a);
if (mod(a,2) = 0) then
dbms_output.put_line('B');
else
dbms_output.put_line('A');
end if;
end;

if u try to execute the above code ,it's executing file
You just need to check with the data type of columns u refering .

Whenever u get such error it is just bcz of improper datatype U defined .
Previous Topic: Dynamic table selection
Next Topic: Triggers
Goto Forum:
  


Current Time: Tue Jun 02 10:14:26 CDT 2020