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 .