a procedure one in two out parameters i am waiting it in a
sql query can i get the output
- 1 Answers
- 4241 Views
- I also Faced
- E-Mail Answers
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
What is trigger point?
What is trigger in flip flop?
What are dml commands?
What is a recursive stored procedure?
what is the difference between delete and truncate statement in sql? : Sql dba
Can you do multiple joins in sql?
Why do we need databases?
What is a null value?
Explain clause in sql?
How do you create a db file?
What are the string functions in sql?
What are the syntax and use of the coalesce function?
how would concatenate strings in mysql? : Sql dba
What is the use of sqlerrd 3?
What are sql injection vulnerabilities?
