|
SQL>
SQL> SET ECHO ON
SQL> SET SERVEROUTPUT ON
SQL> DECLARE
2 fixed_length_10 CHAR(10);
3 fixed_length_20 CHAR(20);
4 var_length_10 VARCHAR2(10);
5 var_length_20 VARCHAR2(20);
6 BEGIN
7
8 fixed_length_10 := 'ZZZZ';
9
10
11 IF fixed_length_10 = 'ZZZZ' THEN
12 DBMS_OUTPUT.PUT_LINE('Char and constant: '''
13 || fixed_length_10 || ''' = ''' || 'ZZZZ' || '''');
14 END IF;
15
16 END;
17 /
Char and constant: 'ZZZZ ' = 'ZZZZ'
PL/SQL procedure successfully completed.
|