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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

John JB Brock-Oracle
Answer

This is a bug in JET v12 that was fixed with the v13 release.

Marked as Answer by User_QH8O4 · Aug 16 2022
User_QH8O4

Thank you John for the response, I appreciate the help.

1 - 2

Post Details

Added on Sep 15 2021
17 comments
4,277 views