<div>
The <a href="https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sqlrf/REPLACE.html#GUID-1A79BDDF-2D3B-4AD4-98E7-985B2E59DA6B" rel="ugc">REPLACE</a> function should do what you need.
</div>


<div>
First: &nbsp;You should ask Oracle questions in the Oracle Database Topic Area. &nbsp;Some of us don't monitor other areas and can easily miss questions. &nbsp;I've changed the Topic Areas for you.<br />
<br />
You really don't provide enough information.<br />
<br />
Do you have stored procedures/functions/packa<wbr />ges that have that email address in them that you want to replace?<br />
Do you have a folder in some OS that has a lot of scripts that you wish to replace?<br />
What?<br />
<br />
If in Oracle code, you can use a query against user_source to find the code that has the domain:<br />
select name, type from user_source where lower(text) like '%@abc.com%';<br />
<br />
Then you can use dbms_metadata.get_ddl to extract the actual DDL, to a simple replace with your favorite editor and re-execute the DDL.
</div>


<div>
&gt;&gt;it would end up looking something like this:<br />
<br />
The assumption is they are using a single email address column in a table or series of tables. &nbsp;The problem is more involved if there is the possibility of more than one column in a table that might contain the email address.<br />
<br />
It also assumes @abc.com is the entire end of the field. &nbsp;If you are updating a column where the email address can exist in blocks of text, the above statements won't work. &nbsp;You will need to double-ended wildcard in my example.
</div>


<div>
<div class="content wysiwyg-content">
In my sql query I am pulling all the email address from my company; example john.smith@abc.com<br />
We are changing our domain to john.smith@hospital.org<br />
<br />
Want to know if there is a way for me to search for the string @abc.com and replace it with @hospital.org in my query?
</div>
</div>


In my sql query I am pulling all the email address from my company; example john.smith@abc.com
We are changing our domain to john.smith@hospital.org

Want to know if there is a way for me to search for the string @abc.com and replace it with @hospital.org in my query?

Character Replace in Oracle SQL

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.