Variables

Data Types

• Scalar

Number, Date, Boolean, Character

• Large Object

Large Text, Picture - BFILE, BLOB, CLOB, NCLOB

• Composite

Collections, Records

• Reference

--NUMBER(precision,scale) v_number NUMBER(5,2) := 5.01; v_character VARCHAR2(20) := 'test'; newyear DATE:='01-JAN-2020'; current_date DATE:=SYSDATE;