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 are two statement types in sql?
How is use pl and sql?
How many types of privileges are available in sql?
what are rollup and cube in t-sql? : Transact sql
Why is the cursor important?
Which normal form is best?
What is query syntax?
what is online transaction processing (oltp)? : Sql dba
Explain what is sql?
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
What is microsoft t sql?
What is an example of translating a date into julian format?
What is function and procedure?
What is string data type in sql?
How can we store rows in PL/SQL using array?