Hé Geeks, I have a table that each row contains data (line), and I want to extract all patterns that match in each line, the actuel comportement of the udf rexexp_extract returns me one occurence match!! but with regexp_replace the comportement is différent (replace all pattern match in line) how can I extract all pattern match in each line ??
select (line,'*.(pattern_match_group).*, index_group) as truc from my_table Thanks by advance ;) Matouk -- *Matouk IFTISSEN | Consultant BI & Big Data[image: http://www.ysance.com] * 24 rue du sentier - 75002 Paris - www.ysance.com <http://www.ysance.com/> Fax : +33 1 73 72 97 26 *Ysance sur* :*Twitter* <http://twitter.com/ysance>* | Facebook <https://www.facebook.com/pages/Ysance/131036788697> | Google+ <https://plus.google.com/u/0/b/115710923959357341736/115710923959357341736/posts> | LinkedIn <http://www.linkedin.com/company/ysance> | Newsletter <http://www.ysance.com/nous-contacter.html>* *Nos autres sites* : *ys4you* <http://wwww.ys4you.com/>* | labdecisionnel <http://www.labdecisionnel.com/> | decrypt <http://decrypt.ysance.com/>*