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.

Can we use pl sql in mysql?

1013

---

What is native sql query?

1025

---

What does desc stand for?

1072

---

Which operator is used in query for pattern matching?

1089

---

What is normalization in sql?

1016

---

Is left join faster than inner join?

1125

---

What do you mean by “trigger” in sql?

1080

---

what does the t-sql command ident_incr does? : Transact sql

1078

---

discuss about myisam index statistics collection. : Sql dba

952

---

What are different categories of sql commands?

1133

---

what are different types of collation sensitivity? : Sql dba

1067

---

What does dml mean?

988

---

Does sql require a server?

1018

---

Determine if oracle date is on a weekend?

1041

---

What are the uses of sysdate and user keywords?

1105

---