WAP to use while loop in PL/SQL

WAP to use while loop in PL/SQL
step-1

RUN THIS COMMAND

create table tb1(id number);
  
IF SUCCESSFULLY RUN THEN WRITE PL/SQL COMMAND
step-2

declare
vid number:=0;
begin
while(vid<=10)
loop
insert into tb1(id)
values(vid);
vid:=vid+1;
dbms_output.put_line(vid);
end loop;
end;

WAP to use for-loop in PL/SQL

WAP to use for-loop in PL/SQL
step-1

create table tb1(id number);
  
RUN THIS COMMAND, IF SUCCESSFULLY RUN THEN WRITE PL/SQL COMMAND
step-2

declare
vid number:=0;
begin
for vid in 1..10
loop
insert into tb1(id)
values(vid);

dbms_output.put_line(vid);
end loop;
end;

WAP to use cursor in pl/sql

WAP to use cursor in pl/sql
step-1 create a table

create table student(stdRollNo number, stdName varchar2(25), 

stdClass varchar2(25));
  
RUN these COMMAND IF SUCCESSFULLY RUN THEN WRITE
step-2 insert 2 or more values

insert into student
values(01,'ABC','XII');
  
RUN these COMMANDs, IF SUCCESSFULLY RUN THEN WRITE PL/SQL COMMAND
step-3
  
declare
vid number;
vname varchar2(25);
cursor std is
select stdRollno,stdName 
from
student
where stdClass='XII';

begin
open std;
loop
fetch std into vid,vname;
exit when std%notfound;
dbms_output.put_line(vid);
end loop;
close std;
end;

WAP to use for-reverse loop in PL/SQL

WAP to use for-reverse loop in PL/SQL
step-1

create table tb1(id number);
  
RUN THIS COMMAND, IF SUCCESSFULLY RUN THEN WRITE PL/SQL COMMAND
step-2

declare
vid number:=0;
begin
for vid in reverse 1..10
loop
insert into tb1(id)
values(vid);

dbms_output.put_line(vid);
end loop;
end;

WAP to use procedure in pl/sql

WAP to use procedure in pl/sql
step-1 create a table

create table student(stdRollNo number, stdName varchar2(25)

, stdClass varchar2(25));
  
RUN these COMMANDs, IF SUCCESSFULLY RUN THEN WRITE PL/SQL COMMAND
step-2
 
create or replace procedure
print(vid number,vname varchar2(25))
is
begin
insert into student(stdRollno,stdName)
values(vid,vname);
end print; 
 
RUN these COMMANDs, IF SUCCESSFULLY RUN THEN WRITE following 

COMMAND
step-3
 
begin
print(01,'xyz');
end print; 

WAP to use loop in PL/SQL

WAP to use loop in PL/SQL
step-1

create table tb1(id number);
 
RUN THIS COMMAND, IF SUCCESSFULLY RUN THEN WRITE PL/SQL COMMAND
step-2
 
declare
vid number:=0;
begin
loop
vid:=vid+1;
insert into tb1(id)
values(vid);
if(vid>=10) then
exit;
end if;
dbms_output.put_line(vid);
end loop;
end;

PL/SQL command

PL/SQL
step-1 create a table

create table student(stdRollNo number, stdName varchar2(25), 

stdClass varchar2(25));
  
RUN THIS COMMAND, IF SUCCESSFULLY RUN THEN WRITE PL/SQL COMMAND

step-2 
 

declare
vid number:=1;
vname varchar2(25):='xyz';
vclass varchar2(25):='X';
begin
insert into student(stdRollNo, stdName , stdClass)
values(vid,vname,vclass);
end;