Answer Posted / roopesh kumar

We can write a procedure with or w/o using parameters.

For procedure the simplest ex. could be like as

SQL> create or replace procedure tr ---calling procedure
2 as
3 begin
4 in_emp; -- Called procedure
5 end;
6 /

in this procedure i am calling another procedure inside
that.

What are the ddl commands?

1011

---

What is package in pl sql with an examples?

1035

---

Why is stored procedure faster than query?

960

---

What does fetching a cursor do?

1088

---

What is cursor in pl sql with examples?

1033

---

How can you load microsoft excel data into oracle? : aql loader

1174

---

How do you modify a table in sql?

1125

---

What is cursor in pl sql?

1117

---

what are dynamic queries in t-sql? : Transact sql

1021

---

What is sqlca in db2?

963

---

What is pl sql script?

1032

---

Write a unique difference between a function and a stored procedure.

996

---

What is the difference between join and natural join?

927

---

How do you update a value in sql?

1043

---

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

1269

---