PL/SQL program for Inserting Values in a table.

Creating the table:

Create table suppliers29 (s_id varchar2(20), name varchar2(20), salary number(10));


PL\SQL Block:

DECLARE
status varchar2(20);
BEGIN
status:='&status';
loop
if(status='y')then
insert into supplier29 values('s1001','abc',8765);
end if;
status:='&status';
dbms_output.put_line('want  another(y/n)');
if(status='n')then
exit;
end if;
end loop;
END;