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;

Explain what is a field in a database and record in a database?

1097

---

What are synonyms in sql?

973

---

What is sqlcommand?

1032

---

Is sql better than access?

1018

---

How do I trace sql profiler?

985

---

what are the differences between require and include, include_once and require_once? : Sql dba

1023

---

How to set up sql*plus output format in oracle?

1038

---

what is the difference between delete and truncate commands? : Sql dba

1070

---

How do you optimize a stored procedure query?

999

---

What will you get by the cursor attribute sql%found?

964

---

What is dba in sql? : SQL DBA

1044

---

Is json a nosql?

982

---

How can you know that statistics should be updated?

1079

---

What is offset in sql query?

1121

---

how can you see all indexes defined for a table? : Sql dba

1000

---