Reverse output of Oracle regexp_replace

Asked Nov 29 '15 at 16:14

Active Nov 29 '15 at 17:36

Viewed 41 times

I've got a variable: v_NumInOne VARCHAR2(2342) := 234534564567

Then with the next line I've seperated it, using: (REGEXP_REPLACE((v_NumInOne), '(....)','\1 ' ));

The result: 2345 3456 4567

Now I'd like to reverse the output.

Expected result: 4567 3456 2345.

edited Nov 29 '15 at 17:36

asked Nov 29 '15 at 16:14

Levialhan

Look also here for a more elegant approach: http://stackoverflow.com/questions/381231/hidden-features-in-oracle. – Hellmar Becker Nov 29 '15 at 16:17
@lad2025 that link helped me a lot, thanks! – Levialhan Nov 29 '15 at 17:41

0 Answers0