Create Query:
select name, replace(name,'e','a') from customer_t5;Output:
NAME REPLACE(NAME,'E','A' -------------------- -------------------- pratik pratik aman aman dilkhush dilkhush Ajay Ajay shiva shiva dilkhush dilkhush jayesh jayash