Meaning of CHR in Oracle

CHR (10) and CHR (13) -- line feed in Oracle
CHR (32) -- indicates space

CHR (9) -- I don't know what it means. The following shows that it is neither a space nor a tab key.

 

Declare
V_a varchar2 (255 );
V_ B varchar2 (255 );
Begin
Select 'A' | CHR (9) | 'B' into V_ B from dual;

V_a: = 'a B '; -- the tab key is used between A and B.

Dbms_output.put_line (V_ B );
Dbms_output.put_line (v_a );
If v_a = V_ B then
Dbms_output.put_line ('v _ A is equal to V_ B ');
End if;
End;

 

The output result indicates that the two are not equal.

 

 

 

Declare
V_a varchar2 (255 );
V_ B varchar2 (255 );
Begin
Select 'A' | CHR (9) | 'B' into V_ B from dual;
V_a: = 'a B '; -- A and B are spaces.
Dbms_output.put_line (V_ B );
Dbms_output.put_line (v_a );
If v_a = V_ B then
Dbms_output.put_line ('v _ A is equal to V_ B ');
End if;
End;

The output result indicates that the two are not equal.

 

 

 

However, when Oracle exports data to excel, different fields can be saved to different Excel columns using CHR (9.