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
Explain the the delete statements in sql?
how to drop an existing view in mysql? : Sql dba
How is indexing done in search engines?
what are the types of subquery? : Sql dba
Why indexing is needed?
What is the use of <> sql?
How is data stored on a disk?
What is trigger explain it?
Why stored procedure is faster than query?
What do you mean by rowid?
How do you define a foreign key?
Is sql a backend?
Are null values same as that of zero or a blank space?
What is a clob in sql?
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?