Interested to Buy Any Domain ? << Click Here >> for more details...
can we use out parameter in a function?Give an example.
- 4 Answers
- 16311 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 |
Mention what plvcmt and plvrb does in pl/sql?
Why partition by is used in sql?
What are different types of keys?
How do I delete a trigger?
What will you get by the cursor attribute sql%found?
What is full join?
What pl/sql package consists of?
What are transaction and its controls?
what is a database lock ? : Sql dba
How do you explain an index number?
How many types of primary keys are there?
What is error ora-01000: maximum open cursors exceeded
-
Oracle (3253) - 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)
