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 multiple columns?

1120

---

how would you enter characters as hex numbers? : Sql dba

1038

---

what is commit? : Sql dba

1127

---

what is union? : Sql dba

1083

---

Explain the difference between triggers and constraints?

1025

---

Is microsoft sql free?

1142

---

What is trigger in pl sql?

1051

---

how does a local variable is defined using t-sql? : Transact sql

1061

---

What is pl sql collection?

1017

---

What are synonyms in sql?

1027

---

What is the difference between Union and Union all. Which is faster.

1442

---

Is sql better than excel?

1227

---

Why are indexes and views important to an organization?

1000

---

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

1175

---

How do I view a sql trace file?

1064

---