Answer / hamdy

Yes we can use dbms_output.put_line in a function,

Function is a subprogram used for do some business process
or some calculations and return value.
DBMS_output.put_line used for Print something to the screen

Answer / 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.

Answer / shail

The significance of using dbms_output can be while
debugging any plsql unit and nothing more.

Answer / swapandeep

this statement is only used for print nothing more.

Answer / a.jyothsna

instead of return we can't use document_output......
But for general we can use

Answer / gourvendra singh

Yes we can use the dbms_output.put_line in a function and
it will print the msg when we execute Function_name, it
will not display any value if we use the function to return
a value, consider the following code:
create or replace function abc_test return char is
a varchar2(20);
begin
select dname into a from dept where deptno=20;
dbms_output.put_line('the dept is ');
return a;
exception
when others then
a:='no dept';
dbms_output.put_line('the dept is ');
return a;
end;

this will work.

Answer / manoj

I agree with Babu with that there is no significance of
dbms_output...in the function..

Explain ttitle and btitle.

0 Answers  

What are the types of views in sql?

0 Answers  

What are the return values of functions SQLCODE and SQLERRM ?

2 Answers   PreVator,

Is big data nosql?

0 Answers  

what is a composite primary key ? : Sql dba

0 Answers  

What is the main difference between a UNION statement and a UNION ALL statement? 1. A UNION statement eliminates duplicate rows; a UNION ALL statement includes duplicate rows. 2. A UNION statement can be used to combine any number of queries; a UNION ALL statement can be used to combine a maximum of two queries. 3. A UNION statement can only combine queries that have parallel fields in the SELECT list; a UNION ALL statement can combine queries with differing SELECT list structures. 4. A UNION statement cannot be used with aggregate functions; a UNION ALL statement can be used with aggregate functions. 5. There is no difference between the two statements; they are interchangeable.

2 Answers   Saman Bank, Sonata,

What do you understand by case manipulation functions?

0 Answers  

What are the datatypes a available in PL/SQL ?

2 Answers  

what is oracle sql,pl/sql with interfaces

2 Answers   TCS,

What will you get by the cursor attribute sql%notfound?

0 Answers  

In a Distributed Database System Can we execute two queries simultaneously ? Justify ?

3 Answers  

Show code of a cursor for loop.

0 Answers