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 sql profiling in oracle?

739


What is record variable?

708


What is a temp table?

746


Name some usages of database trigger?

748


what are all the common sql function? : Sql dba

779






What is primary and foreign key?

806


What is the non-clustered index in sql?

753


Which sql statement is used to return only different values?

711


What is update query?

711


What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

722


Is sql an operating system?

720


What is scope of pl sql developer in future?

748


The select into statement is most often used to create backup copies of tables or for archiving records?

771


How does postgresql compare to mysql?

761


What is primary key secondary key alternate key candidate key?

765