LIKE command

LIKE command

select stdName,stdAddress
from student
where stdName like 'ABC'

Give yourself more screen real estate in Windows 7’s

Give yourself more screen real estate in Windows 7’s.
These tips apply primarily to Windows 7

You can shrink Windows 7’s oversize taskbar icons by right-clicking the taskbar, 

choosing Properties, and selecting Use small icons. This option shrinks the size of the taskbar by half, giving you a few extra millimeters of vertical screen space.

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;

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;