Interested to Buy Any Domain ? << Click Here >> for more details...
a procedure one in two out parameters i am waiting it in a
sql query can i get the output
- 1 Answers
- 4615 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 the maximum rows in csv?
What is secondary key?
Is natural join same as inner join?
What is query optimization in sql?
What are conditional predicates?
What is pl sql code?
Can you do multiple joins in sql?
How do you sort in sql?
Is mariadb nosql?
Who developed sql?
What is the use of double ampersand (&&) in sql queries? Give an example
Why truncate is used in sql?
What are two statement types in sql?
Is pl sql a programming language?
Can we use join in subquery?
