<p>I have a string coming from a table like "can no pay{1},as your payment{2}due on {3}". I want to replace {1} with some value , {2} with some value and {3} with some value .</p>

<p>Is it Possible to replace all 3 in one replace function ? or is there any way I can directly write query and get replaced value ?   I want to replace these strings in Oracle stored procedure the original string is coming from one of my table I am just doing select on that table </p>

<p>and then I want to replace {1},{2},{3} values from that string to the other value that I have from another table </p>

Although it is not one call, you can nest the
```
replace()
```
calls:
```
```
SET mycol = replace( replace(mycol, '{1}', 'myoneval'), '{2}', mytwoval)
```
```