Oracle - What Is a Procedure in Oracle

Home > Oracle

What Is a Procedure in Oracle

Q

What Is a Procedure in Oracle?

✍: FYIcenter.com

A

A procedure is a named program unit. It consists of three parts:

Declaration Part - Defining the procedure name, calling parameters, local variables and local procedures. Declaration part is required.
Execution Part - Defining execution logic with executable statements. Execution part is required.
Exception Part - Defining error handling logics. Exception part is optional.

Here how a complete procedure should look like:

PROCEDURE name (parameter_1, parameter_2) AS
  -- Declaration statements
BEGIN
  -- Executable statements
EXCEPTION
  -- Error handling statements
END;

⇒Creating Oracle PL/SQL Procedures and Functions

⇒⇒Oracle Database Tutorials

2018-01-27, 542👍, 0💬

What Is a Function in Oracle
What Is a Function in Oracle? A function is a named program unit. It consists of three parts: Declaration Part - Defining the function name, calling parameters, return value type, local variables and local procedures. Declaration part is required. Execution Part - Defining execution logic with execu... 2018-01-27, 564👍, 0💬

What Is a Procedure in Oracle
What Is a Procedure in Oracle? A procedure is a named program unit. It consists of three parts: Declaration Part - Defining the procedure name, calling parameters, local variables and local procedures. Declaration part is required. Execution Part - Defining execution logic with executable statements... 2018-01-27, 543👍, 0💬

Define Anonymous Procedures without Variables in Oracle
How To Define an Anonymous Procedure without Variables in Oracle? Anonymous procedure is a procedure without any name. If you don't have any variables to declare, you can define an anonymous procedure by using the BEGIN keyword directly in SQL*Plus as shown in the following tutorial script: SQL&... 2018-01-27, 526👍, 0💬

Test NULL Values in Oracle
How To Test NULL Values in Oracle? There ate two special comparison operators you can use on NULL values: "variable IS NULL" - Returns TRUE if the variable value is NULL. "variable IS NOT NULL" - Return TRUE if the variable value is not NULL. The following sample script shows you examples of compari... 2018-07-13, 521👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.