Oracle Query fetching table name alongwith column name
select trx_id,refernce number from
(select * from abcd_1_txt union
select * from abcd_2_txt union
select * from abcd_3_txt union
select * from abcd_4_txt)
where trx_id in (123,321,1234)
In the query all the tables are of same format, same column names and same
number of columns. After running this query, surely i will get some data.
My question --- is there any way to know from which of these tables, i am
getting the output.
No comments:
Post a Comment