Mega Code Archive
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>