Answer Posted / madhav

create or replace procedure proc_in_out
(p_empno in number,p_ename out varchar2)
as
begin
.......
.......
end;
execute proc_in_out(7369,p_ename)--out parameter can't
like this

declare
v_ename varchar2(10);
begin
proc_in_out(7369,v_ename);
end;

what is a database transaction? : Sql dba

822

---

how to create a new table in mysql? : Sql dba

714

---

What is pl sql in oracle?

784

---

What is trigger explain with example?

751

---

What is auto increment in sql?

823

---

---

what is offset-fetch filter in tsql? : Transact sql

715

---

Why are aggregate functions called so?

681

---

How to select random rows from a table?

726

---

What is record type in pl sql?

747

---

What is right join in sql?

744

---

What is graph sql?

721

---

Can function return multiple values in sql?

733

---

Is join an inner join?

718

---

Can you skip header records while loading? : aql loader

730

---

What are sql data types?

744

---