Answer Posted / soujanya

See the example below...

create or replace procedure addn(a in number,b in number, c
out number)
is
begin
c:=a+b;
dbms_output.put_line(c);
end addn;

Now we can call the in and out parameters as

declare a variable for the out parameter as

var n number;
exec addn(5,10,:n);
print n;

Explain how exception handling is done in advance pl/sql?

558

---

How to use sql*plus built-in timers?

578

---

How do you identify a primary key?

635

---

What is the purpose of a sql?

532

---

How do I find duplicates in a single column in sql?

538

---

---

How do I find duplicates in two columns?

555

---

What are the triggers associated with image items?

621

---

What are the sql aggregate functions?

612

---

how to get a list of indexes of an existing table? : Sql dba

518

---

How do I create a sql script?

542

---

How do I truncate a sql log file?

540

---

Which are the different case manipulation functions in sql?

539

---

What is pl/sql table? Why is it used?

561

---

What is data modelling in sql?

523

---

what is data control language? : Sql dba

588

---