Answers

Question and Answer:

  Home  Oracle Database

⟩ How To Declare a Local Variable?

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;

 223 views

More Questions for you: