Thursday, October 21, 2004

Oracle INSERT data

damy PK for ID and EntityCode:

create procedure ba_dealerreportinitialdata is
ecnum number; yyy number; uniqueIDVar VARCHAR2(16);
BEGIN
select identifier into ecnum from private_entity_identifier where name='SIBDealerReportType'; yyy := 1;
uniqueIDVar := 'UniqueId' yyy;
insert into DealerReportType (sibID, sibEntityCode, reportTypeName) values (uniqueIDVar, ecnum, 'CSI Results');
yyy := yyy + 1;
uniqueIDVar := 'UniqueId' yyy;
insert into DealerReportType (sibID, sibEntityCode, reportTypeName) values (uniqueIDVar, ecnum, 'KPI Reports');
yyy := yyy + 1;
uniqueIDVar := 'UniqueId' yyy;
insert into DealerReportType (sibID, sibEntityCode, reportTypeName) values (uniqueIDVar, ecnum, 'TCR Reports');
yyy := yyy + 1;
uniqueIDVar := 'UniqueId' yyy;
insert into DealerReportType (sibID, sibEntityCode, reportTypeName) values (uniqueIDVar, ecnum, 'Benchmark Reports');
END;

begin ba_dealerreportinitialdata;
end;

drop procedure ba_dealerreportinitialdata;

No comments: