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 sql statements are used?

0 Answers  

---

What is percent sign in sql?

0 Answers  

---

What are the advantages of sql?

0 Answers  

---

How to pronounce postgresql?

0 Answers  

---

what is the difference between a local and a global temporary table? : Sql dba

0 Answers  

---

What is the difference between drop and truncate commands?

0 Answers  

---

How do you update sql?

0 Answers  

---

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  

---

i have xml source. xml source having lacks of records. i want extract/retrive xml source data using sql query. please tell me how to write query.

4 Answers   TCS,

---

What is pl/sql table? Why it is used?

0 Answers  

---

Explain two easy sql optimizations.

0 Answers  

---

What is rownum in sql?

0 Answers  

---