Using 'Listagg' function and 'Regular Expression' to REVERSE the value of a specific column in Oracle
select col_id, reverse(col_name) as col_name from tbl_test;

    COL_ID COL_NAME  
---------- ----------
         1 pantea    
         2 apple     
         3 banana