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 working of foreign key?
Which certification is best for sql?
what is a field in a database ? : Sql dba
what is 'mysqlimport'? : Sql dba
How do you create an update query?
Explain the difference between 'between' & 'and' operators in sql
What is the most restrictive isolation level? : Transact sql
Can we have two clustered index on a table?
What is normalisation and its types?
what is innodb? : Sql dba
What is substitution variable?
What are dml commands?
What is a null value?
What is graph sql?
Can we use rowid as primary key?