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 is cte sql?

718

---

How much ram can sql express use?

699

---

What is oracle sql called?

673

---

what is online transaction processing (oltp)? : Sql dba

713

---

what is query cache in mysql? : Sql dba

762

---

---

How do I install microsoft sql?

715

---

What is a recursive join sql?

806

---

What is sql in java?

756

---

How delete a row in sql?

717

---

When sql appeared?

815

---

Explain the order of sql statement execution?

806

---

What is the use of stored procedures?

706

---

What is keys and its types?

749

---

How do I edit a stored procedure?

724

---

How does index help in query performance?

761

---