Scalar Data Types

Scalar Data Types


  • CHAR [(maximum_length)]
  • VARCHAR2 (maximum_length)
  • NUMBER [(precision, scale)]
  • BINARY_INTEGER
  • PLS_INTEGER
  • BOOLEAN
  • BINARY_FLOAT
  • BINARY_DOUBLE
  • DATE
  • TIMESTAMP
  • TIMESTAMP WITH TIME ZONE
  • TIMESTAMP WITH LOCAL TIME ZONE

 

Declaring Scalar Variables


DECLARE
v_e_job VARCHAR2(9);
v_count BINARY_INTEGER := 0;
v_total_sal NUMBER(9,2) := 0;
v_hire_date  DATE := SYSDATE + 7;
c_rate CONSTANT NUMBER(3,2) := 8.25;
v_status  BOOLEAN NOT NULL := TRUE;

Leave a Reply

Your email address will not be published. Required fields are marked *