How To Declare a Local Variable

Q

How To Declare a Local Variable? - Oracle DBA FAQ - Understanding PL/SQL Language Basics

✍: 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;

2007-04-30, 5115👍, 0💬