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.

Mention what is the plv (pl/vision) package offers?

1090

---

What packages are available to pl/sql developers?

1023

---

What is cursor in pl sql with examples?

1009

---

What is a relationship and what are they?

1120

---

Can we create view in stored procedure?

943

---

What is sql query limit?

955

---

How do I find duplicates in two columns?

1125

---

What is rtm stands for?

1076

---

Can we use pl sql in sql server?

1060

---

how to install mysql? : Sql dba

1086

---

Explain exception handling in pl/sql?

1016

---

What is triggering circuit?

1049

---

what is sp_pkeys? : Transact sql

1135

---

What is Difference Between Unique and Primary Key Constraints?

1090

---

What is difference between inner join and self join?

1067

---