Skip to Main Content

SQL & PL/SQL

Search for value in field across database

User_7WIPYSep 15 2021 — edited Sep 15 2021

Version 12c: simple really … how do I search for a value across all tables within a database?
example:
database name: Dallas
Multiple tables
searching for value : 956377
Search maybe for text or numeric value.
value may appear in multiple tables and multiple fields.

Comments
Post Details
Added on Sep 15 2021
17 comments
2,476 views