Regex - extracting numbers from string in Oracle SQL : <p>how to extract using SQL or PL/SQL all numbers from below strings? </p>

<p>[ 6d (1.5h; 31h)] x (5 to 7)</p>

<p>[ 1d (8h; 24h; 48.5h; 72h; 96h)] x (1 to 5)</p>
