Send this as an enhacment request to monitor@softtreetech.com. Such feature may be added to the dbFind in a near future. If you are dealing with a small number of tables you can build a script like define search_string 'Blue'; select 'emp' table_name, 'name' column_name, name data_value from emp where name like %&search_string% union all select 'emp' table_name, 'favorite_color' column_name, favorite_color data_value from emp where favorite_color like %&search_string% union all select 'emp' table_name, 'job' column_name, job data_value from emp where job like %&search_string% union all select 'dept' table_name, 'name' column_name, name data_value from dept where name like %&search_string% union all select 'dept' table_name, 'wall_color' column_name, wall_color data_value from emp where wall_color like %&search_string% ; If you run such script using DBA Notepad you would get the output like Table Name Column Name Data Value emp favorite_color Blue dept wall_color BlueGreen You will need to declare a substitution variable called for example search_string. So that to change the criteria for a new search all you need to do before running the script is to change the first line. For example to serach for Grean change it to "define search_string 'Green';" : Right, but what I am looking for is slight different. : Lets say for instance you have 2 tables, emp and dept. The tables are setup : as follows ... : EMP : Name Favorite Color Job : DJ Blue Not Much : Sam Red Same Thing : DEPT : Name Wall Color : Dev BlueGreen : Eng Purple : So, I being the CEO get hit by a blue car and am not happy with the color. I : decide that Blue must be stricken from our database. I want a report that : will search the entire database for any value %BLUE% and return the : table_name, and column_name in something like this: TABLE_NAME COLUMN_NAME : VALUE : emp favorite_color Blue : dept wall_color BlueGreen : See, it is like a full table search of each column and each row in a database : for a specific value to return the table_names and column_names for each : instance where that record occurs. : DJ
|