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 we rollback after truncate?

1025

---

Can we group by two columns in sql?

985

---

What do you understand by pl/sql packages?

1058

---

What is linq to sql?

1129

---

How do I order columns in sql?

992

---

how to extract a unit value from a date and time? : Sql dba

988

---

What are all the different normalizations?

1025

---

How do you define a foreign key?

992

---

How to write a query to show the details of a student from students table whose

992

---

How do I run pl sql in sql developer?

1110

---

how to enter characters as hex numbers? : Sql dba

1033

---

What are the string functions in sql?

969

---

what is try_catch block in procedure

1733

---

how tsql statements can be written and submitted to the database engine? : Transact sql

978

---

what is meant by nl2br()? : Sql dba

1031

---