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;

explain mysql aggregate functions. : Sql dba

549

---

What is the difference between cluster and non-cluster index?

622

---

What is a full join sql?

593

---

Does sql*plus also have a pl/sql engine?

563

---

What does <> sql mean?

542

---

---

What is difference between cursor and trigger?

559

---

How do I find sql profiler?

521

---

how to escape special characters in sql statements? : Sql dba

518

---

what is the command used to fetch first 5 characters of the string? : Sql dba

1136

---

What is secondary key?

510

---

Can %notfound return null after a fetch?

593

---

what are the limitations of identity column? : Transact sql

608

---

what is a tablespace? : Sql dba

564

---

What do we need to check in database testing?

561

---

Is inner join same as self join?

586

---