GitHub

Oracle PL/SQL stored procedure to search a regular expression across all text columns of a database.

The output of the procedure is in CSV format (without headers). Each row is a match found in the database. For each match, the columns are the searched pattern, the schema name, the table name, the ...
GitHub

Thin mode only: "ORA-00979: not a GROUP BY expression"

I am seeing the error "ORA-00979: not a GROUP BY expression" when in thin mode, but the same program works in Thick mode. Seems to be triggered by the interaction of ...