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;

What is embedded sql in db2?

972

---

What is record type in pl sql?

954

---

How to display the current date in sql?

1024

---

What is full join?

903

---

how many ways we can we find the current date using mysql? : Sql dba

1051

---

Is record in pl sql?

928

---

what is the difference between undefined value and null value? : Sql dba

1052

---

What is auto increment feature in sql?

1082

---

What is the maximum number of rows in sql table?

974

---

What are the methods of filing?

892

---

Does normalization improve performance?

997

---

What is a unique constraint?

1029

---

What does (+) mean in sql joins?

1032

---

How does sql developer connect to oracle database?

964

---

what are the different type of normalization? : Sql dba

982

---