Does oracle database have a mechanism to replace specific character when storing data

oracleoracle-11g

I'm using oracle 11g database, does oracle database have a mechanism to replace specific character with other characters over all tables when storing data. For example i want to go to specific configuration place in oracle and specify these characters ﻙ, ﻱ to be replaced with these ک, ی that are Arabic characters.

I'm beginner in oracle database.

Best Answer

The database does not offer such an option that you asked for.

It is the responsibility of the client/application to insert correct data into the database.

If you want to change existing data, you can use the TRASNLATE function to replace each occurence of specific characters.

update table1 
set column1 = translate(column1, 'AB', 'XY')
where column1 != translate(column1, 'AB', 'XY');
Related Question