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;

Comments