Answer Posted / parivesh sinha

yes.

create or replace function p_tst (v_p out varchar2) return
varchar as
v_g varchar2(50);
begin
select ENAME2 into v_p from emp where empno='11';
return v_p;
end;

Explain select statements in sql?

759

---

What does trigger mean in psychology?

708

---

What is form and report?

714

---

How to write a query to show the details of a student from students table whose

755

---

Is left join same as inner join?

723

---

---

What is nvl?

790

---

What is the syntax and use of the coalesce function?

812

---

What is the meaning of disabling a trigger?

826

---

Can we use views in stored procedure?

705

---

How do you declare a constant?

708

---

Can we create index on primary key?

716

---

Which one is better subquery or joins?

775

---

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

753

---

What is sql*loader and what is it used for?

742

---

How do sql databases work?

714

---