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 commit statement.
what are the advantages and disadvantages of views in a database? : Sql dba
What is composite data type in pl sql?
Explain the difference in execution of triggers and stored procedures?
What is vector point function?
What is the difference between functions, procedures, and packages in pl/sql?
Which table is left in left join?
What are different methods to trace the pl/sql code?
Do we need commit after truncate?
What company owns postgresql?
Can we use pl sql in mysql?
What is a temporal data type?
What is a primary key sql?
How much does a sql dba make? : SQL DBA
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?