Can we use out parameter in function?

Answer Posted / suresh babu

Yep,we can use the out parameter in Function,the Function won't show the error when using the out parameter.But it is meaningless.The Function,which used the out parameter never return the result.The IN parameter only useful for Functions.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why partition by is used in sql?

564


What is the difference between left and left outer join?

524


What is execute immediate?

557


Is there any restriction on the use of union in embedded sql?

689


What is native sql query?

565






How you can copy a file to file content and file to pl/sql table in advance pl/sql?

634


Define the select into statement.

582


Can we join tables without foreign key?

530


what is the difference between primary key and unique key? : Sql dba

537


define data blocks ? : Sql dba

554


Define overloaded procedure?

632


How to use sql*plus built-in timers?

584


what is heap table? : Sql dba

620


what is the syntax for using sql_variant_property? : Transact sql

543


How can you create an empty table from an existing table?

602