a procedure one in two out parameters i am waiting it in a
sql query can i get the output
Answer Posted / 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 View All Answers
How do I run pl sql in sql developer?
What is varchar sql?
how to enter characters as hex numbers? : Sql dba
What is user defined functions?
What is varray in pl sql?
How do you remove duplicates without using distinct in sql?
Can we use rowid as primary key?
What is the purpose of design view?
What is field delimiter?
Write a query to display the current date in sql?
What does the hierarchical profiler does?
Is subquery faster than join?
What is the difference between having clause and where clause?
What packages(if any) has oracle provided for use by developers?
Why we use stored procedure instead of query?