varchar2 type value with not null default value
SQL> SQL> DECLARE 2 lv_test_txt VARCHAR2(5) NOT NULL DEFAULT 'HELLO'; 3 BEGIN 4 DBMS_OUTPUT.PUT_LINE('Test Value: ' || lv_test_txt); 5 END; 6 / Test Value: HELLO PL/SQL procedure successfully completed. SQL> SQL>