can we use out parameter in a function?Give an example.

Question Posted / dibya

4 Answers
14533 Views
Logica CMG, TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

can we use out parameter in a function?Give an example...

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;

Is This Answer Correct ?

18 Yes

5 No

can we use out parameter in a function?Give an example...

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.

Is This Answer Correct ?

4 Yes

3 No

can we use out parameter in a function?Give an example...

Answer / mahesh

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

Is This Answer Correct ?

2 Yes

3 No

can we use out parameter in a function?Give an example...

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

Is This Answer Correct ?

0 Yes

4 No

Post New Answer