Answer Posted / chakri

Syntax of procedure :

CREATE OR REPLACE PROCEDURE proce_name (Arg list)
IS
LOCAL VARIBLE DECLARATION

BEGIN
----------
----------
---------
END;


In the about syntax

Up to IS key word called as Procedure Header and

Remaining Part is called as Procedure Body.

What is recursive stored procedure?

600

---

What is the maximum database size for sql express?

536

---

What is sql injection owasp?

546

---

What is partition by in sql?

569

---

Is sql microsoft?

545

---

---

How do temporal tables work?

517

---

how to get @@error and @@rowcount at the same time? : Sql dba

526

---

What is field delimiter?

633

---

Explain the advantages and disadvantages of stored procedure?

647

---

What is sqlcommand?

551

---

Why do we need view in sql?

547

---

What is time based sql injection?

486

---

how to drop an existing view in mysql? : Sql dba

568

---

What is rank () in sql?

531

---

How do I order columns in sql?

525

---