Re: insert extra rows(s) in a SELECT statement
Posted by:
Mike Cook
Date: February 17, 2012 05:12AM
Thanks for your suggestion Irek. That's sort of what I had in my own mind for handling this. I was hoping there might be a more "dynamic" option that didn't involve creating a secondary table though. While my example was simple, in reality the table is quite large (~20k records inserted per day).
Also, to refer back to my example, technically the value "b" for "2012-02-15 02:00:00" isn't real - so while I want to show it temporarily in some queries, I'd rather not have it stored in the DB itself so as to not confuse the fact that it doesn't really exist.
Perhaps the easiest solution is to manipulate the data outside of the database (say via PHP/ASP for a web-based display) rather than through the query itself
Subject
Views
Written By
Posted
2200
February 15, 2012 10:43AM
998
February 16, 2012 04:39PM
Re: insert extra rows(s) in a SELECT statement
877
February 17, 2012 05:12AM
732
February 18, 2012 11:05PM
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.