Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


a procedure one in two out parameters i am waiting it in a
sql query can i get the output



a procedure one in two out parameters i am waiting it in a sql query can i get the output..

Answer / aurobinda

yes ,we can

create or replace procedure (v_empno in emp.empno%
type,v_ename out emp.ename%type,v_sal out emp.sal%type)
is
begin
select ename,sal into v_ename,v_sal from emp
where empno =v_empno);
dbms_output.put_line(v_ename||' '||v_sal);
end;

Is This Answer Correct ?    4 Yes 3 No

Post New Answer

More SQL PLSQL Interview Questions

How do you update sql?

0 Answers  


Does mysql_real_escape_string prevent sql injection?

0 Answers  


What are the parts of a basic sql query?

0 Answers  


What is the use of sqlerrd 3?

0 Answers  


What is a system versioned table?

0 Answers  


What is a sql schema used for?

0 Answers  


how will u find statistics of a database objects?

2 Answers   iFlex,


What do you understand by pl/sql records?

0 Answers  


What is minus?

0 Answers  


Can we create view in stored procedure?

0 Answers  


How do I run a pl sql program?

0 Answers  


Explain constraints in sql?

0 Answers  


Categories