Can we use out parameter in function?

Answer Posted / reddyreddy143

1.Yes we can use out parameters in a function.but we have
to assign the out parameter value to the return datatype.
2.But when we use out parameters in function we can't call
the function from a select statement

Is This Answer Correct ?    10 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are types of joins?

701


Is pl sql a scripting language?

777


How many types of cursors are available in pl/sql?

769


What is compound trigger?

752


What are local and global variables and their differences?

803






How can I speed up sql query?

704


what is the difference between cluster and non cluster index? : Sql dba

728


What's the difference between inner join and left join?

721


what is normalization? : Sql dba

737


How to add new employee details in an employee_details table with the following details

821


What is trigger in sql? Explain

696


How to display the records between two range in Oracle SQL Plus?

868


What types of commands can be executed in sql*plus?

760


what are all different types of collation sensitivity? : Sql dba

708


what are sequences

1312