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;

difference between SQL and C

1 Answers   Indus Software Technologies,

---

Differences between UNIQUE and DISTINCT in select statements

26 Answers   ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro,

---

what is dbms? : Sql dba

0 Answers  

---

How can we optimize a sql query?

0 Answers  

---

how can we submit a form without a submit button? : Sql dba

0 Answers  

---

---

How can you view the errors encountered in a trigger?

0 Answers  

---

What is window clause?

1 Answers   TCS,

---

what is inline view?

15 Answers  

---

What is user define exception and example

1 Answers   HP, KP,

---

What is oracle sql called?

0 Answers  

---

How delete a row in sql?

0 Answers  

---

cursor types? explain with example programs?

1 Answers   HP,

---