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;
/

What is sql and its types?

817

---

What is compute?

734

---

What is database migration?

696

---

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

2761

---

What is an implicit commit?

762

---

---

What is trigger in flip flop?

729

---

How can you select unique records from a table?

701

---

What is audit logout in sql profiler?

764

---

How does a trigger work?

718

---

What is sqlservr exe?

694

---

What does select * from mean in sql?

2539

---

Is primary key is clustered index?

724

---

What is the use of prepared statement?

749

---

What are literals in sql server?

738

---

How to test for null values?

767

---