will function return more than one value how
- 9 Answers
- 24405 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 delete statement be rollbacked?
what is bcp? When does it used? : Sql dba
what are all the common sql function? : Sql dba
How do I remove duplicates in two columns?
Can we rollback truncate?
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
Is inner join faster than left join?
Do we need to rebuild index after truncate?
define sql insert statement ? : Sql dba
what is schema? : Sql dba
What is the current version of sql?
how to escape special characters in sql statements? : Sql dba
What is the best sql course?
what is collation? : Sql dba
how many tables will create when we create table, what are they? : Sql dba
