Hi Team,
I need to search a value say "NIK" in all tables of a database.
Let suppose we have two tables:
TAB1
| SL No | Name | Emp No |
| 1 | ABC | 123 |
| 2 | XYZ | 111 |
| 3 | NIK | 245 |
TAB2
| SL No | Username | User ID |
| 1 | DEF | 231 |
| 2 | NIK | 235 |
| 3 | LMN | 124 |
So I need a query where if a search a string say "NIK", then it should display output as
| Table Name | Column Name | Value |
|---|
| TAB1 | Name | NIK |
| TAB2 | Username | NIK |
Please help in getting the SQL query.
My database version is Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit .