Monday, 9 September 2013

Oracle Query fetching table name alongwith column name

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