This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 31st, when you will be able to use this site as normal.

    Forum Stats

  • 3,890,647 Users
  • 2,269,776 Discussions
  • 7,916,827 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