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;

Does sql*plus also have a pl/sql engine?

1074

---

what are the advantages of mysql in comparison to oracle? : Sql dba

994

---

What do you mean by field in sql?

1075

---

what does it mean to have quoted_identifier on? : Sql dba

1140

---

What is #table in sql?

1084

---

explain what is mysql? : Sql dba

1076

---

The select into statement is most often used to create backup copies of tables or for archiving records?

1062

---

What does where 1 1 mean in sql?

1033

---

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

994

---

What is the difference between the repeatable read and serializable isolation levels? : Transact sql

1092

---

What is fmtonly in sql?

1077

---

What is a primary key example?

956

---

What is difference sql and mysql?

973

---

What is pl sql script?

1026

---

What is secondary key?

929

---