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;

what is 'mysqladmin' in mysql? : Sql dba

1024

---

Why primary key is required?

998

---

What does bitemporal mean?

1059

---

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

960

---

What does truncate mean in sql?

1017

---

What are triggers in sql?

1014

---

What is the difference between unique and primary key constraints?

1062

---

What is graph sql?

981

---

How do I upgrade sql?

998

---

Does google use sql?

950

---

What is pls_integer in pl sql?

1093

---

Explain foreign key in sql?

1016

---

What is scalar data type in pl sql?

1060

---

Explain exception handling in pl/sql?

1033

---

How does a trigger work?

1060

---