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 |
what is the Default Libraries for Oracle Report 6i
query to retrive the employees whose sal is greater than avg sal
What is 19 null in sql?
How to convert ms-excel file to oracle table?
How pl/sql source code can be protected?
what is SCALAR Queries?
What is audit logout in sql profiler?
What is gpt format?
What is the full form of sql?
What is cursor and why it is required?
Can you create a table with Primary Key not as the clustered index.
Explain the insert into statements in sql?