sprintf_inverse gets a string to parse, a format string and an integer (0,1 or 2) that indicates error recovery method. If the first argument matches the format string then it returns vector of the pattern values.
SQL> select sprintf_inverse ('qwe123asd456zxcABRACADABRA', 'qwe%dasd%dzxc%s', 2); callret VARCHAR _______________________________________________________________________________ vector(123,456,0x00adfae8) 1 Rows. -- 0 msec. SQL>
SQL> select sprintf_inverse ('---123', '%-R', 2); callret VARCHAR _______________________________________________________________________________ vector(0x00b070e8) 1 Rows. -- 0 msec. SQL>