NOT command

NOT command

select * 
from student
where not stdAddress='gao'

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;

Snap windows faster

Snap windows faster.
These tips apply primarily to Windows 7
Source: PC World

But what if you like Aero Snap? Here is a faster way to snap 

windows right or left by using keyboard shortcuts instead of 

the mouse.  snaps left, and  snaps right. While we’re at it,  

will maximize your window, while  will minimize it. 

(Note, however, that if you have done the Registry hack 

described in the preceding tip to turn off Aero Snap, that 

hack will have disabled these particular shortcuts, too.)

Get a quick peek at the desktop

Get a quick peek at the desktop.
These tips apply primarily to Windows 7

Simply click  to hide all open windows. Keep the  held down and 

then release that key to return to your former environment with 

all its open windows in place.