Declare Local Variables in Oracle

Q

How To Declare a Local Variable in Oracle?

✍: FYIcenter.com

A

A local variable can be defined in the declaration part with a declaration statement, which is a variable name followed a data type identifier. Below are some examples of declaration statements:

PROCEDURE proc_var_1 AS
  domain VARCHAR2(80);
  price REAL;
  is_for_sale CHAR;
BEGIN
  -- Executable statements
END;

 

Initialize Variables with Default Values in Oracle

PL/SQL Functions in Oracle

Understanding PL/SQL Language Basics

⇑⇑ Oracle Database Tutorials

2018-11-17, 1720🔥, 0💬