Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Data Types

 

BINARY_INTEGER in action

Both of these datatypes exist only in PL/SQL, and you cannot create a column of these types. SQL> SQL> declare   2      variable1_nr BINARY_INTEGER;   3      variable2_nr PLS_INTEGER;   4  begin   5     NULL;   6   7  end;   8  / PL/SQL procedure successfully completed. SQL> SQL> -- SQL>