Finding substring that starts with ':' until the first space after the ':' character
<p>I want to find a substring that starts with <code>:</code> and ends with <code>"</code>, and then replace all occurrences with <code>dd/mm/yyyy</code>. </p>

<p>How is this possible using oracle <code>regexp_replace</code>?</p>

<p>For example, <code>to_date('13/09/2016',:"SYS_B_08")</code> should become <code>to_date('13/09/2016','dd/mm/yyyy')</code>.</p>

<p>Thank you. Best regards.</p>

<p>;) </p>