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;

How do I count records in sql?

514

---

What is the difference between a subquery and a join?

527

---

Can we commit in trigger?

543

---

What is the max nvarchar size?

513

---

What is union, minus and interact commands?

746

---

---

describe mysql connection using mysql binary. : Sql dba

548

---

How do temporal tables work?

514

---

What is raw datatype in sql?

548

---

What does dml mean?

543

---

What are the advantages of pl sql?

600

---

what is “go” in t-sql? : Transact sql

596

---

What is sqlite used for?

528

---

What are functions in sql?

507

---

What is a temp table?

565

---

Where not exists in sql?

503

---