906451 wrote:I do not have the book with me at present ... it is helping me remeber how to lop branches off of a pigs ear to save whole trees.
Thanks a lot.
I've downloaded and installed oracle 11g on my machine and connected sql developer now but there are no tables like SHIPS and CRUISES used in the book.
Is there someway I can get them to practise upon ?
dfcii wrote:I think both viewpoints are valid.
IMHO, I would have suggested that one build the schemas and tables they need from scratch. If one is to be an Oracle Certified Expert in SQL, one should be able to do perform those tasks quickly and accurately. I realize that in larger shops, those tasks might be/are deligated to the DBA team, but having worked in both small and large shops, I believe that being an "expert" should include more than the ability to copy source code and run somoene else's sql scripts.
Edited by: dfcii on Jan 9, 2012 6:57 AM