1.

How To Initialize Variables With Default Values?

Answer»

There are TWO ways to assign default values to variables at the time of declaration:

  • Using key word DEFAULT - Appending "DEFAULT value" to the END of declaration statements.
  • Using assignment operator - Appending ":= value" to the end of declaration statements.

The SCRIPT below show you some examples of declaration statements with default values:

PROCEDURE proc_var_1 AS domain VARCHAR2(80) := 'fyicenter.com'; price REAL DEFAULT 999999.99; is_for_sale CHAR := 'N'; BEGIN -- EXECUTABLE statements END;

There are two ways to assign default values to variables at the time of declaration:

The script below show you some examples of declaration statements with default values:


Discussion

No Comment Found

Related InterviewSolutions