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 the difference between mdf and ndf files?
What is the difference between distinct and unique in sql?
What are the qualities of 2nf?
What is embedded sql with example?
what is the difference between cluster and non cluster index? : Sql dba
Does sql support programming?
how is myisam table stored? : Sql dba
How to create an array in pl/sql?
what is an extent ? : Sql dba
what is datawarehouse? : Sql dba
What is the plv (pl/vision) package offers?
Can I join the same table twice?
What is difference between procedure and trigger?
What type of database is cloud sql?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?