SELECT * from vmw_log, regexp_capture(log_body, '--> /SessionStats/SessionPool/Session/(?[abc]+)') sql_keyword ------ sql_oper - sql_keyword ---- sql_ident ------- sql_comma - sql_func -------------------------------------------------------------------------------- sql_ident -------------- sql_ident -------- sql_comma - sql_string -------------------------------------------------------