Answer Posted / naren

i think by this code u may understand



create or replace procedure p1(a out number) as
begin
a:=10;
end;
/


create or replace procedure p2 as
b number;
begin
p1(b);
dbms_output.put_line('value of inner pro paramter is:'||b);
end;
/


this code work successfully and pass a(out param of p1)
into b(variable of p2).

Mention what is the use of function "module procedure" in pl/sql?

1006

---

What is sql architecture?

982

---

What is the purpose of my sql?

900

---

difference between anonymous blocks and sub-programs.

1080

---

How many clustered indexes can be created on a table?

1023

---

What is a constraint? Tell me about its various levels.

1082

---

Why do we use procedures in sql?

1021

---

Can you have a foreign key without a primary key?

900

---

What is trigger in pl sql?

955

---

What is view? Can we update view

1352

---

how to see the create table statement of an existing table? : Sql dba

946

---

Is oracle and sql same?

954

---

What is the difference between clustered and non-clustered index in sql?

957

---

Explain normalization and what are the advantages of it?

891

---

how to add a new column to an existing table in mysql? : Sql dba

1001

---