How to return more than one value from a function?

Answer Posted / swapna

We can return one more than one value by using reference
cursors.

Is This Answer Correct ?    26 Yes 11 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many tables can a sql database have?

528


How many types of indexes are there in sql?

534


Is progress software supports to ( pl/sql )?

521


What is input buffer in sql*plus?

634


what is 'mysqlimport'? : Sql dba

568






What is difference between primary and secondary key?

515


Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3101


Which sql statement is used to return only different values?

498


Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

1715


What is a data manipulation language?

568


what are the performance and scalability characteristics of mysql? : Sql dba

523


What is difference between stored function and application function?

590


What is informix sql?

533


Is inner join faster than left join?

628


What is the use of index in hive?

545