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 is lookup table in sql?

615


Why do we use %rowtype & %type in plsql?

618


what is sql server agent? : Sql dba

614


What is program debugging?

582


Why triggers are used?

565






What do you mean by query optimization?

556


What is the example of procedure?

529


Write a sql query to convert all character to uppercase after hypen.

973


List the different type of joins?

584


What is sap sql anywhere?

543


Can a view be mutating? If yes, then how?

586


How to Execute a Package in PL/SQL.?

601


What is pl sql in dbms?

510


What is the life of an sql statement?

531


What is pl sql record in oracle?

571