Earn by twitter on twivert

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

Saturday, December 4, 2010

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;

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