View with Union

I have 2 tables, i want to display data from both tables as single data, i wanted to display data in real time, i don’t want to fill to third table and display. any oracle like VIEW with UNION option available?, no relation between two table data. i want to display record based on entry time from both table as a single data. Msisdn ending with 0 to 5 is coming to one table, 6 to 9 is coming into another table, so i want to combine both data and display as single table data in real time .

Hi @zachariam,

we have UNION ALL, but it has to be activated with a server’s parameter called enable-union

You can check this discussion for examples.

Take care about the usage of union-all because you could face some performance problems, especially when dealing with big tables using many fields.


1 Like