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

What is transaction control language (tcl)?

746


Can we call dml statement in function?

647


Can a primary key be a foreign key?

663


How are functions and procedures called in PL/SQL?

689


What is a schema? How is it useful in sql servers?

682






What are the 3 types of behavioral triggers?

815


How do you explain an index?

875


What is a pl/sql block?

682


What is clause?

692


How do you create an update query?

622


What is sql*loader?

668


What is structural independence and why is it important?

649


Can pl sql procedure have a return statement?

646


what is the syntax used for partition in tsql? : Transact sql

636


what are wild cards used in database for pattern matching ? : Sql dba

656