Answer / parivesh sinha

yes.

create or replace function p_tst (v_p out varchar2) return
varchar as
v_g varchar2(50);
begin
select ENAME2 into v_p from emp where empno='11';
return v_p;
end;

Answer / sanket

Actual parameter:Actual parameter is a parameter which are
actually pass to the procedure or function.
Formal parameter:Formal parameter is a parameter which we
are defining while declaring procedure.

Answer / mahesh

wht is actaul and formal parameters and wht is the main
difference
can any one knows this answer kindly inform me

Answer / friend

Actual parameter:these are the parameters where we use in
exection of a procedure
Formal parameter:these are the parameters where we use as
in and out parameters

What is the purpose of using pl/sql?

0 Answers  

---

Is join same as left join?

0 Answers  

---

what is the difference between clustered and non clustered index in sql? : Sql dba

0 Answers  

---

How to load data with sql*loader?

0 Answers  

---

Is left join same as join?

0 Answers  

---

What is primary key in db?

0 Answers  

---

What is a mutating table

5 Answers   TCS, Tech Mahindra,

---

what is Difference between Having and Where clause?

5 Answers   IBM,

---

How to get the 3rd column(i.e all the data along with the column name)in a table?

2 Answers   Logica CMG,

---

IF EMP HAS 2 ROWS,DEPT HAS 4 ROWS.WHATS THE RESULT OF SELECT * FROM EMP,DEPT;

1 Answers  

---

Use The Implicit cursor to Query The Department table information Where Deptno is 30.check,if no record was found then print "Record Was Not Found".Else Print Deptname And Ename.Dept table Have Dname Varchar2(20),Deptno Number,EnameVarchar2(20).Please Answer In 2 mins,with in Maximum 15 lines.

5 Answers   Wipro,

---

How exception handling is done in advance pl/sql?

0 Answers  

---