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

Leave a Reply

Subscribe to Posts | Subscribe to Comments

All Notes on BCA

All Notes  on BCA
BCA all subjects notes

Total Pageviews

Translate

Powered by Blogger.

Copyright © All Notes on BCA