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 |
how can we know the count/number of elements of an array? : Sql dba
What is $$ in sql?
What are the basic techniques of indexing?
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
what is the difference between primary key and unique key? : Sql dba
What is the usage of NVL?
7 Answers Infosys, Micro Infotek,
What are sql objects?
define primary key & secondary key?
What is sql*loader?
What is a sql statement?
Can you load data into multiple tables at once? : aql loader
What is sql partition function?