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.

Will truncate release space?

887

---

How do I create a memory optimized filegroup?

903

---

What is set serveroutput on?

1086

---

What is the purpose of the primary key?

1004

---

How run sql*plus commands that are stored in a local file?

975

---

What are stored procedures in mysql?

967

---

What are different types of sql?

1098

---

What is difference between rank () row_number () and dense_rank () in sql?

1049

---

What is normalisation in sql?

1002

---

Explain commit, rollback and savepoint.

931

---

What does subquery mean in sql?

988

---

What is difference between sql and excel?

1006

---

Describe types of sql statements?

990

---

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

3924

---

What are different types of triggers?

1025

---