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

how to select unique records from a table? : Sql dba

1175

---

how many ways we can we find the current date using mysql? : Sql dba

1144

---

How does join work in sql?

1052

---

What does the acronym acid stand for in database management?

1088

---

what is the command line end user interface - mysql? : Sql dba

1028

---

Is left join same as inner join?

1216

---

What is the difference between partitioning and sharding?

1050

---

how many groups of data types? : Sql dba

1075

---

What is nosql vs sql?

1225

---

What does count (*) mean in sql?

1653

---

Is oracle and sql same?

1077

---

What is set serveroutput on in pl sql?

1359

---

Why select is used in sql?

1069

---

How do I make sql search faster?

1044

---

What do you understand by case manipulation functions?

1079

---