Comparison of CHAR with VARCHAR2

  
SQL> -- Comparison of CHAR with VARCHAR2.
SQL>
SQL> SET SERVEROUTPUT ON
SQL> SET ECHO ON
SQL>
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 := 'String';
  7    employee_name_v := 'String';
  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>

Related examples in the same category

1.	The CHAR data type is used for storing fixed-length character strings.
2.	char type with 50 characters
3.	Define varchar2 type variable
4.	Define and use char value
5.	set column width by setting char number
6.	CHAR() and VARCHAR2()
7.	'' represents a zero length character string BUT NOT a null value
8.	No equality comparison between two '' strings
9.	Compare char value without knowing the case
10.	Convert string to clob
11.	char type and varchar2 type
12.	Memory allocation differences between the CHAR and VARCHAR2 datatypes

Comparison of CHAR with VARCHAR2 : CHAR « Data Type « Oracle PL / SQL

Related examples in the same category