Interested to Buy Any Domain ? << Click Here >> for more details...
can we use out parameter in a function?Give an example.
- 4 Answers
- 15952 Views
- Logica CMG, TCS, I also Faced
- E-Mail Answers
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 |
Explian rowid, rownum? What are the psoducolumns we have?
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
How do you write a subquery?
What is group by in sql?
What are the types of queries in sql?
What is oracle sql developer?
What is the need of merge statement?
What is Overloading of procedures ?
What is difference between pl and sql?
Should I use mbr or gpt?
How to call the function and Procedure in trigger?
how many no of table can be join in a sql query.
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
