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

How many types of literals are available in pl sql?

0 Answers  

---

Do we need commit after truncate?

0 Answers  

---

How do I install sql?

0 Answers  

---

What do you mean by “trigger” in sql?

0 Answers  

---

What are the PL/SQL Statements used in cursor processing ?

4 Answers  

---

what is the difference between where clause and having clause? : Sql dba

0 Answers  

---

What is self-join and what is the requirement of self-join?

0 Answers  

---

what is meant by forward declaration in functions?

4 Answers   TCS,

---

Where is pl sql used?

0 Answers  

---

Can we use distinct and group by together?

0 Answers  

---

Like shown below i have 3 columns(Name,No,Address). The values in name column i want to modity. Requirement : Keep only once space between two words (Fname,Lname) in the Name column. For this what is the query? Please answer me. Advance Thanks. Name No Address Reference manoj kumar kumar raja vinzay kumar rajendra prasad gowri nath -- -- --

5 Answers  

---

how to findout the 100th maximum salary

28 Answers   Amdocs,

---