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 a boolean in sql?
What is the starting oracle error number?
What is difference between sql and oracle?
What does <> sql mean?
Is it possible to create startup or shutdown trigger for on-schema?
How to run sql*plus commands in sql developer?
Are views faster than queries?
what is a control file ? : Sql dba
What is data modelling in sql?
What is out parameter used for eventhough return statement can also be used in pl/sql?
Is sql port 1433 encrypted?
What is %type in sql?
What is compute?
What is a field in a database?
What are string functions in sql?