SQL & PL/SQL

Hi All,

1. We have a data in excel which is to be loaded in our Oracle table.
2. Data has special characters example @, + , - , line break
3. As per our database rules except .,comma & single quote everything else is restricted and gets converted to pipe |
4. to bypass this restriction we converted all special charaters to there ASCII code example @ get converted to chr(64) , + to chr(43)
5. example email - cs@abc.com gets converted to ‘cs’||chr(64)||'abc.com'
6. we anticipated that when we read the data chr(64) would be converted to @
7. example select ‘cs’||chr(64)||'abc.com' from dual gives cs@abc.com
8. But, since this data ‘cs’||chr(64)||'abc.com' was loaded into c_dtls colums of table Company it is displayed as same
9. select c_dtls from company gives ‘cs’||chr(64)||'abc.com'
10. Example data attached

Kindly help why point 7 and 9 has different output and how can i solve the same

special character issue.xlsx