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

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

More SQL PLSQL Interview Questions

how to convert dates to character strings? : Sql dba

0 Answers  


What is sql server and ase?

0 Answers  


What is PL/SQL table ?

6 Answers  


what is a primary key? : Sql dba

0 Answers  


How can we implement rollback or commit statement in a trigger?

0 Answers  






what is purge command explain about oracle performance tuning

2 Answers   Accenture, eCentric Solutions,


Which sql statement is used to delete data from a database?

0 Answers  


How do I truncate a word?

0 Answers  


how are mysql timestamps seen to a user? : Sql dba

0 Answers  


Which command is used to call a stored procedure?

0 Answers  


Is oracel sql developer written in java?

0 Answers  


Give the structure of the function ?

2 Answers  


Categories