will function return more than one value how
- 9 Answers
- 22377 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / chaitra
A function can return more than one value if the function
is returning a data structure like PL/SQL Table, REF CURSOR
etc.
But returning more than one value by the use of OUT
parameter cannot be done as this fails when the function is
called from an SQL statement ( as in where var = fn(..)).
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
Can sql function call stored procedure?
what is blob? : Sql dba
What is the difference between in and between in sql?
what is collation? : Sql dba
Can instead of triggers be used to fire once for each statement on a view?
Can you call pl/sql package functions from within a fast formula?
What is bind reference and how can it be created?
How many types of cursors are available in pl/sql?
What is memory optimized table?
What are the types of subqueries?
Can you inner join the same table?
Does truncate remove indexes?
What is the difference between delete and truncate commands?
What is db journal file?
what are the authentication modes in sql server? : Sql dba
