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;

What found sql?

0 Answers  

---

Explain uses of cursor.

1 Answers  

---

How many functions are there in sql?

0 Answers  

---

what is the different between unique+not null & primary key,

4 Answers  

---

how to do backup entire database? : Transact sql

0 Answers  

---

---

What are sql data types?

0 Answers  

---

i have a table emp and columns ename,empno,mgr_id,i need ename,manager name as result i.e employee respective manager.. example empno ename mgr_id 1 john 3 2 paul 3 3 smith 1 4 kevin 1 5 stewart 2 result has to look like this ename manager john smith paul smith smith john kevin john stewart paul can u plz help me out in this.....

8 Answers  

---

how to get second highest salary in SQL(as/4000

29 Answers   iGate,

---

How to change sql*plus system settings?

0 Answers  

---

Can a procedure in a package be overloaded?

0 Answers   EXL,

---

how can you create an empty table from an existing table? : Sql dba

0 Answers  

---

What is a natural join?

0 Answers  

---