Included in a different column in the same table, it appears as if the procedure does not findĭbms_application_t_client_info( '%' || p_string || '%' ) ĭbms_output.put_line('Data Searched: ' || p_string) įor x in ( select table_name from all_tables where owner = 'APDBMS_SOR' Two places where the schema is specified in the code.ģ.) This procedure seems to stop searching a table after it finds a hit. If changing the schema, note that there are "Current Schema" drop-down, to run as that user. MUST select the correct schema, in TOAD's Included a criteria for OWNER that is not found in the original procedure.ġ.) MUST use the "Execute as script" button. Had to use the ALL_TAB_COLUMNS table, instead of the USER_TAB_COLUMNS table. That you do not need to create the procedure first. This adaptation allows the procedure to run in anonymous mode, which means * Adaptation of Tom Kyte procedure to search all tables in an Oracle database for a particularĭata value. I know it is not good database design to have data repeated in two columns, but it is what it is.I have no control of the existing design. I have found that if two columns in the same table include the search term (same data), only the first column found will be displayed in the output. My question relates to the third comment. I have copied the procedure below, sans a few comments internal to the company I work for, that I cannot share. This one is specific to this search procedure.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |