Question

what is a procedure . explain the part of the procedure

Answer 1

Explanation:

A “procedure” is a term used in a variety of industries to define a series of steps, taken together, to achieve a desired result. Procedures explain how to accomplish a task. A procedure is sometimes called a work instruction. If you are preparing an ISO 9001 quality management system, then the term procedure is used to describe a process, whereas a work instruction is used to describe something more basic like a specific step in a process. For example, how to fill out a form. Procedures are known in other ways too.

Answer 2

Answer:

A procedure is a subprogram that can take parameters and be called. Generally, you use a procedure to perform an action. A procedure has two parts: the specification and the body. The specification (spec for short) begins with the keyword PROCEDURE and ends with the procedure name or a parameter list. Parameter declarations are optional. Procedures that take no parameters are written without parentheses. The procedure body begins with the keyword IS (or AS) and ends with the keyword END followed by an optional procedure name.

The procedure body has three parts: an optional declarative part, an executable part, and an optional exception-handling part. The declarative part contains declarations of types, cursors, constants, variables, exceptions, and subprograms. These items are local and cease to exist when you exit the procedure. The executable part contains statements that assign values, control execution, and manipulate Oracle data. The exception-handling part contains handlers that deal with exceptions raised during execution.

Explanation:

Hope this will help uh!!