New answers tagged tools
I particularly like this one which works from within your (firefox) browser. If you're not a firefox user, then here is a list of alternatives.
Generate ERD with PHPMyAdmin is also a better option. PHPMyadmin added this functionality from version 3.4 detail step to generate ERD : http://goo.gl/0z3vFE You can refer to PHPMyAdmin documentation for more info: http://www.phpmyadmin.net/documentation/#pmadb
I agree that a temporary table (or "hash table" # in SQL Server speak) will do what you want. If you want to do this graphically I can recommend a product called "Lavastorm Analytics BRE". There is a free desktop version and it will allow you to view datasets on the fly. It can also do a few things you can't do with conventional SQL such as an inner and ...
It seems to me that you might want one of two things to do what you require. 1) could be global temporary tables (GTTs), see here or here. Check out the Oracle docco here for drier technical detail. 2) might be CTEs - Common Table Expressions (or subquery factoring as Oracle calls it) - also known as the "WITH CLAUSE". Howtos are here and here - (again, ...
Top 50 recent answers are included