Earn by twitter on twivert

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

Saturday, November 27, 2010

WAP to use procedure in pl/sql


WAP to use procedure in pl/sql
step-1 create a table

create table student(stdRollNo number, stdName varchar2(25)
, stdClass varchar2(25));
  
RUN these COMMANDs, IF SUCCESSFULLY RUN THEN WRITE PL/SQL COMMAND
step-2
 
create or replace procedure
print(vid number,vname varchar2(25))
is
begin
insert into student(stdRollno,stdName)
values(vid,vname);
end print; 
 
RUN these COMMANDs, IF SUCCESSFULLY RUN THEN WRITE following 
COMMAND
step-3
 
begin
print(01,'xyz');
end print; 
 
 

OR command


OR command
select stdName 
from student
where stdRollno=2 or stdRollno=3

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