Forum Stats

  • 3,767,751 Users
  • 2,252,713 Discussions
  • 7,874,327 Comments

Discussions

Search for value in field across database

User_7WIPY
User_7WIPY Member Posts: 7 Green Ribbon
edited Sep 15, 2021 2:53AM in SQL & PL/SQL

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.

Tagged:
«1

Answers