Re: Find Underlying Table From Merge Table?
I am also interested in a *real* solution from this.
Isn't there any other way then using union selects?
I have one mail table for each month, mail_year_month and a mail merge table.
If there was a way to SELECT id,sentdate,REAL_TABLE_NAME FROM mail_merge_table then i could convert my sentdate from DATETIME to TINYINT UNSIGNED and just store the day number and save some table space.
Using union selects in this case is too complicated since my merge table currently have over 60 underlying tables.
Subject
Views
Written By
Posted
8368
March 06, 2006 12:00PM
5092
March 06, 2006 06:48PM
Re: Find Underlying Table From Merge Table?
4541
January 27, 2007 07:19AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.