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 are records give examples?

1010

---

What is varchar sql?

1146

---

What is a nested table in word?

958

---

Is it possible to read/write files to-and-from PL/SQL?

1103

---

What is the sql query to display the current date?

1044

---

what is cross join? : Sql dba

998

---

What is on delete set null?

1090

---

What is the maximum rows in csv?

924

---

What is left join in postgresql?

1048

---

What is trigger types of trigger?

1070

---

How do I write a cron which will run a sql query and mail the results to agroup?

981

---

Can we use loop in sql?

970

---

What is orm in sql?

1050

---

Is natural join same as inner join?

943

---

what is a trigger? : Sql dba

1030

---