Oracle DUMP function

Use oracle DUMP function to see internal representation of a character field, e.g. to see hidden trailing characters as in example below:

select * from m_ghaw_employer_mapping where source_friendly_id like 'BULS_6930%' or source_friendly_id like 'BUKIT3425%'; --hidden trailing characters
select ENTERPRISE_ID, EMPLOYER_ID, SOURCE_BUSINESS_ID, dump(SOURCE_FRIENDLY_ID) SOURCE_FRIENDLY_ID from m_ghaw_employer_mapping where source_friendly_id like 'BULS_6930%' or source_friendly_id like 'BUKIT3425%';

ENTERPRISE_ID EMPLOYER_ID SOURCE_BUSINESS_ID SOURCE_FRIENDLY_ID GOVERMENT_AGENCY_FG SETUP_COMPLETED_FG
————- ———– ————————————————– ——————– ——————- ——————
27905692 13034613 3C02DB52-52C1-43B1-98DE-EA75CA9AB7AC BULS_6930 N Y
27905692 13034613 78412D82-5F71-4F37-AF30-39E28A33E55B BUKIT3425 N Y

ENTERPRISE_ID EMPLOYER_ID SOURCE_BUSINESS_ID SOURCE_FRIENDLY_ID
————- ———– ————————————————– ————————————————————–
27905692 13034613 78412D82-5F71-4F37-AF30-39E28A33E55B Typ=1 Len=20: 66,85,75,73,84,51,52,50,53,0,0,0,0,0,0,0,0,0,0,0
27905692 13034613 3C02DB52-52C1-43B1-98DE-EA75CA9AB7AC Typ=1 Len=20: 66,85,76,83,95,54,57,51,48,0,0,0,0,0,0,0,0,0,0,0