set serveroutput on
declare
VEno char(6);
VEname varchar(30);
VESalary number(10,2);
VEDate date;
VEDno char(3);
begin
VEno := '&VEno';
VEname := '&VEname';
VESalary := &VSalary;
VEDate := '&VEDate';
VEDno := '&vEDno';
insert into Emp values(VEno,VEname,VESalary,VEDate,VEDno);
end;
commit;
/
No comments:
Post a Comment
Thanks for showing your interest
I will shortly get back to you