Assign Values to Variables in Oracle


How To Assign Values to Variables in Oracle?



You can use assignment statements to assign values to variables. An assignment statement contains an assignment operator ":=", which takes the value specified on the right to the variable on left. The script below show you some examples of assignment statements:

PROCEDURE proc_var_2 AS
  is_done BOOLEAN;
  counter NUMBER := 0;
  message VARCHAR2(80); 
  is_done := FASLE;
  counter := counter + 1;
  message := 'Hello world!';


Understanding PL/SQL Language Basics

⇒⇒Oracle Database Tutorials

2016-10-17, 136👍, 0💬