Answer Posted / ajit

create or replace procedure P_io ( I_num1 number,
o_num2 out number,
io_num3 in out number
)
is
begin
io_num3 := io_num3 + i_num1;
o_num2 := io_num3;
end;
/

Call this store procedure
--------------------------
declare
a number := 3;
b number;
c number := 7;
begin
P_io ( a, b, c);
dbms_output.put_line ( a||' '||b||' '||c);
end;
/

Why stored procedure is faster than query?

949

---

What are the events on which a database trigger can be based?

1101

---

What are database links used for?

990

---

Explain what is a database?

1037

---

What is pl sql quora?

1071

---

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

934

---

How do I run pl sql in sql developer?

1059

---

Which is faster union or join?

901

---

What are user defined functions?

947

---

How are sql commands classified?

1035

---

What is rowid in sql?

906

---

What is indexes?

1000

---

What are its different types of dbms?

956

---

what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

1084

---

What's the difference between a primary key and a clustered index?

946

---