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;

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

0 Answers  

---

How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?

0 Answers  

---

What are the different types of joins and explain them briefly.

3 Answers  

---

Explain about various levels of constraint.

0 Answers  

---

write a query to find 4th max salary

7 Answers  

---

What is primary key and foreign key with example?

0 Answers  

---

Can a commit statement be executed as part of a trigger?

0 Answers  

---

need to split a string into separate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.

2 Answers  

---

What is sql data?

0 Answers  

---

What is the difference between inner join and natural join?

0 Answers  

---

What does stand for in sql?

0 Answers  

---

What is auto increment?

0 Answers  

---