Search All Fields In All Tables for a LIKE Value

Toad for SQL Server Idea Pond
1

For Toad for SQL SERVER 8.0

I’d like to search all fields in all tables for a value that is like ‘%.0’

I tried using this script via Copilot but it gives me a “varchar2 is not a recognized cursor option” error.

DECLARE
    v_sql VARCHAR2(4000);
    v_value VARCHAR2(100) := '%your_value%'; -- Replace with your LIKE value
BEGIN
    FOR t IN (SELECT table_name, column_name 
              FROM all_tab_columns 
              WHERE owner = 'YOUR_SCHEMA') -- Replace YOUR_SCHEMA with your schema name
    LOOP
        v_sql := 'SELECT ''' || t.table_name || ''' AS table_name, ''' || t.column_name || ''' AS column_name ' ||
                 'FROM ' || t.table_name || ' WHERE ' || t.column_name || ' LIKE :value';
        BEGIN
            EXECUTE IMMEDIATE v_sql USING v_value;
        EXCEPTION
            WHEN OTHERS THEN
                NULL; -- Ignore errors (e.g., incompatible data types)
        END;
    END LOOP;
END;

**I also tried just looking for the value via the object search tool but it turns out with nothing.

Any ideas with this? Thank you.