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

Can primary key be changed?

953

---

What is a sql profiler?

1066

---

What is the non-clustered index in sql?

1107

---

how to create a test table in your mysql server? : Sql dba

1056

---

What is triggering circuit?

1105

---

Which are the different types of indexes in sql?

1099

---

How do you drop a trigger?

1037

---

Does view store data in sql?

1042

---

What operating systems are supported by oracle sql developer?

1015

---

What is a sql*loader control file?

1344

---

What is the difference between a primary key and a unique key?

1108

---

Where is sql database stored?

1039

---

What is difference between sql and mysql?

1194

---

Can we create index on primary key?

1018

---

Can we call dml statement in function?

1099

---