will function return more than one value how
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
what is denormalization. : Sql dba
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
What are the types of triggers in sql?
What is execute immediate?
What is the least restrictive isolation level? : Transact sql
How do you sort in sql?
what's the difference between a primary key and a unique key? : Sql dba
What is rollback?
How to display the current date in sql?
What jobs use sql?
What are procedures used for?
What is the purpose of the primary key?
How do I audit the sql sent to the server?
What is sp_helptext?
What language is oracle sql developer?