1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / arpitha2206


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

Explain the difference between 'between' & 'and' operators in sql

0 Answers  

What is error ora-12154: tns:could not resolve the connect identifier specified?

0 Answers  

difference between table level constraint and column level and advantages of table level constraint

4 Answers   Doyensys,

what are the advantages of package?

7 Answers   iFlex,

Does pl sql work in mysql?

0 Answers  




what are the differences among these table level lock modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE MODE ?

3 Answers   HCL,

What is scope of pl sql developer in future?

0 Answers  

what is the use of double ampersand (&&) in sql queries?

0 Answers  

What are the two types of exceptions in pl/sql?

0 Answers  

How do you clear the screen in sql?

0 Answers  

What is Pragma EXECPTION_INIT ? Explain the usage ?

2 Answers  

Why do we use function in pl sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories