Basic Oracle Concepts and Programming Question:
Download Questions PDF

How To Declare a Local Variable?

Answer:

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;


Download Oracle Database Interview Questions And Answers PDF

Previous QuestionNext Question
What Is a Function?How To Initialize Variables with Default Values?