can i use dbms_output.put_line in a function u are telling
as return statement

Answer Posted / babu

Functions are always called by a program and its duty is to
return a value to the calling program, on the other hand,
dbms_output is used to print something to the screen and it
would not be of any significance here.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you concatenate in sql?

552


Does oracle roll back the transaction on an error?

539


what is subquery? : Sql dba

574


How to run sql functions in pl/sql?

543


How would you pass hints to the sql processor?

532






What language is oracle sql developer?

510


How do I run a query in pl sql developer?

562


Does sql support programming?

557


What is the usage of the distinct keyword?

692


Is clustered index a primary key?

537


What is sql exception?

518


What is the purpose of using pl/sql?

666


how to get a list of columns in an existing table? : Sql dba

545


Define concurrency control. : Transact sql

588


Is sql free?

501