Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Data Types

 

Compare CHAR and VARVHAR32 variables for equality

SQL> SQL> SET SERVEROUTPUT ON SQL> SET ECHO ON SQL> DECLARE   2    employee_name_c CHAR(32);   3    employee_name_v VARCHAR2(32);   4  BEGIN   5    --Assign the same value to each string.   6    employee_name_c := 'CHAR';   7    employee_name_v := 'VARCHAR';   8   9    --Test the strings for equality.  10    IF employee_name_c = employee_name_v THEN  11      DBMS_OUTPUT.PUT_LINE('The names are the same');  12    ELSE  13      DBMS_OUTPUT.PUT_LINE('The names are NOT the same');  14    END IF;  15  END;  16  / The names are NOT the same PL/SQL procedure successfully completed. SQL>