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;

How do you declare a constant?

522

---

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

644

---

What has stored procedures in sql and how we can use it?

561

---

what is heap table? : Sql dba

603

---

How to sort the rows in sql.

598

---

---

What is the difference between between and in condition operators?

531

---

What are database links used for?

591

---

What is character functions?

552

---

What is the difference between cluster and non-cluster index?

616

---

Write a sql select query that only returns each name only once from a table?

564

---

What are the types of optimization?

519

---

Will truncate release space?

514

---

What is an exception in pl/sql?

542

---

how can you create an empty table from an existing table? : Sql dba

656

---

What is the difference between an inner and outer join?

534

---