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;

When do we use triggers?

1081

---

What does trigger mean in slang?

1058

---

Can we use update in sql function?

1064

---

what are date and time data types in mysql? : Sql dba

971

---

Why should I use postgresql?

1018

---

How do I view a procedure in sql?

975

---

Is it possible for a table to have more than one foreign key?

1030

---

what are the differences between binary and varbinary? : Sql dba

1044

---

What is the difference between truncate and drop statements?

1190

---

What is query optimization in sql?

985

---

what are numeric data types? : Sql dba

1064

---

what is self join and what is the requirement of self join? : Sql dba

1145

---

Is and as keyword in pl sql?

961

---

What are all different types of collation sensitivity?

1035

---

How does stored procedure reduce network traffic?

1010

---