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 are some predefined exceptions in pl/sql?

1163

---

what is a control file ? : Sql dba

1032

---

Whis is not false in primary key?

1450

---

What are two statement types in sql?

1085

---

write an sql query to find names of employee start with 'a'? : Sql dba

1023

---

What is the difference between inner join and outer join?

988

---

What is asqueryable?

961

---

Write a query to find the names of users that begin with "um" in sql?

989

---

Compare sql & pl/sql

1127

---

What is synonyms?

1051

---

what is the difference between delete and truncate statement in sql? : Sql dba

1234

---

What is sql not null constraint?

1023

---

What is dml and ddl?

948

---

What is a crud api?

950

---

What is a trigger word?

1018

---