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 can we know the count/number of elements of an array? : Sql dba

0 Answers  


What is $$ in sql?

0 Answers  


What are the basic techniques of indexing?

0 Answers  


suppose we have a table in which 200 rows. i want to find 101 row ? what the query.... and how we find 4th and 5th highest salary and 1 to 10 highest salary

7 Answers  


what is the difference between primary key and unique key? : Sql dba

0 Answers  






What is the usage of NVL?

7 Answers   Infosys, Micro Infotek,


What are sql objects?

0 Answers  


define primary key & secondary key?

2 Answers  


What is sql*loader?

0 Answers  


What is a sql statement?

0 Answers  


Can you load data into multiple tables at once? : aql loader

0 Answers  


What is sql partition function?

0 Answers  


Categories