Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

Processing

Post Details

Added on Sep 15 2021
17 comments
4,322 views