Urgent !! Need Help!!!
From: CME <support_at_cmesys.demon.co.uk>
Date: Thu, 26 Jul 2001 16:52:09 +0100
Message-ID: <996162765.1728.0.nnrp-12.c2de4217_at_news.demon.co.uk>
Date: Thu, 26 Jul 2001 16:52:09 +0100
Message-ID: <996162765.1728.0.nnrp-12.c2de4217_at_news.demon.co.uk>
Hi:
[Quoted] Would you like to tell me how I can convert it from Sybase to Oracle?
Thanks anyway!!!
alter procedure
dba.AddMachine(in sMachineName varchar(56))
result(MACHINEID integer) begin
declare iMachineID integer;
select max(MachineID) into iMachineID from tblMachine where Name =
sMachineName;
if iMachineID is null then
insert into tblMachine(Name) values(sMachineName);
select Max(machineID) into iMachineID from tblMachine
end if
end
Received on Thu Jul 26 2001 - 17:52:09 CEST