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;