Earn by twitter on twivert

Sign up for PayPal and start accepting credit card payments instantly.
Showing posts with label cursor. Show all posts
Showing posts with label cursor. Show all posts

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