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;

Lowercase all-capitals text in a trice

Lowercase all-capitals text in a trice.
These tips apply primarily to Windows 7

In Microsoft Office apps, convert the text to lowercase by 

selecting it and pressing shift + f3.

Press  a second time to convert the text to title case. 

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;