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 the different type of normalization? : Sql dba

550

---

How do I copy a table in sql?

515

---

What is secondary key?

508

---

What is ttitle and btitle?

571

---

how many sql dml commands are supported by 'mysql'? : Sql dba

567

---

---

Mention what does plv msg allows you to do?

662

---

How can you create an empty table from an existing table?

593

---

How to fix oracle error ora-00942: table or view does not exist

566

---

What are sql*plus environment variables?

553

---

What does select * from mean in sql?

1984

---

Is it possible to link two groups inside a cross products after the cross products group has been created?

588

---

what is the command line end user interface - mysql? : Sql dba

496

---

Can we use insert statement in function?

513

---

Can a key be both primary and foreign?

507

---

How to connect a sql*plus session to an oracle server?

618

---