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

types of exceptions and what is meant by pragma autonomous_transaction ?what is the use.

4 Answers   3i Infotech,

What is the difference between row level and statement level trigger?

0 Answers  

Who developed sql?

0 Answers  

What will be the output for the below Query Select 'High' from dual where null = null;

12 Answers   Infosys, Satyam,

write the Sql query for creating database backup?

7 Answers   TCS,

what are different types of keys in sql?

0 Answers  

declare v_count number(8,3); v_sal scott.emp.sal%type := '&P_sal'; cursor cur_name is select sal from scott.emp where sal between (v_sal-100) and (v_sal +1000); begin v_count :=nvl(sql%rowcount ,0); if v_count = 0 then dbms_output.put_line('no records are fetch in the given sal range'); else dbms_output.put_line('There is/are '||to_char(v_count)|| ' salaries are selected in the given range '); end if; end; in the above programm .....for any sal range ....always it shows the following message.. no records are fetch in the given sal range please find the mistake and share with me...with thansk and regards..sarao....

3 Answers   Satyam,

what are the different types of joins?

4 Answers   Choice Solutions,

What are its different types of dbms?

0 Answers  

How do I remove duplicates in two columns?

0 Answers  

What is denormalization in a database?

0 Answers  

Is and as keyword in pl sql?

0 Answers