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
How does sql*loader handles newline characters in a record? : aql loader
How many indexes can be created on a table in sql?
What is trigger and how to use it in sql?
How do I make my sql query run faster?
How many sql core licenses do I need?
Explain the uses of control file.
Is natural join same as inner join?
What are the indexing methods?
How can you select unique records from a table?
Why we use stored procedure instead of query?
How many sql statements are used? Define them.
What is foreign key sql?
what are the disadvantages of mysql? : Sql dba
How can we avoid duplicating records in a query?
How do I tune a sql query?