Earn by twitter on twivert

Sign up for PayPal and start accepting credit card payments instantly.

Wednesday, November 17, 2010

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;

No comments:

Post a Comment

ADS

How to earn online

How to earn online:
Step - 1 :
signup for PayPal, to recieve your online earning
click here:
https://www.paypal.com/in/mrb/pal=CZ7224TZBMCBL
step - 2 : Singup these 4 sites & earn & enjoy! Read site to know how to earn.
1. trekpay
Earn up to $0.02 (2 cents) per click.
http://www.trekpay.com/?ref=34690
2. neobux
Earn up to $0.02 (2 cents) per click.
Click here:
http://www.neobux.com/?r=Moneyearner786

AddMe

Bookmark and Share