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 .

Report message to a moderator

Previous Topic: Dynamic table selection
Next Topic: Triggers
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 14:05:16 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.