can we use out parameter in a function?Give an example.
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
how to convert dates to character strings? : Sql dba
What is sql server and ase?
What is PL/SQL table ?
what is a primary key? : Sql dba
How can we implement rollback or commit statement in a trigger?
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?
How do I truncate a word?
how are mysql timestamps seen to a user? : Sql dba
Which command is used to call a stored procedure?
Is oracel sql developer written in java?
Give the structure of the function ?